Snitz™ Forums 2000
https://forum.snitz.com/forumTopic/Posts/67963?pagenum=1
06 November 2025, 06:40
Topic
Carefree
Restricted Keywords Mod
15 December 2008, 01:54
I wrote this mod because I just cannot remember all 2500+ restricted keywords in 14 different versions of Sql database languages. This one is almost ridiculously easy to install/use.
Make a one line change to admin_home.asp. Click the entry. Type in a word, submit. Done.
The dbs file is appx 2700 lines long. Get your copy at SnitzBitz.<
Replies ...
MarcelG
08 January 2009, 09:15
Craig, I'm trying to understand what this mod is for, but I have absolutely no idea.
What does it do? Does it restrict people from using restricted words in topics?<
HuwR
08 January 2009, 10:06
it just gives you a list of restricted keywords in various flavours of SQL, not sure why.
<
AnonJr
08 January 2009, 10:54
Probably for reference when developing MODs. I distinctly remember spending an ungodly amount of time trying to help someone with an issue related to installing a MOD only to find the MOD was trying to use a MySQL keyword for a column name.<
MarcelG
09 January 2009, 07:23
Ah, so just a reference page. That makes indeed sense. Thanks.<
Carefree
05 May 2009, 15:17
I made an updated version using a smaller table design of this since my issue doing exactly the same thing (beating my head against the wall about a non-listed restricted keyword). I added Jet (where the keyword "password" is restricted), OLAP, Sybase, & some restricted just for Access.
Unfortunately, the dbs file reports errors in the insert functions. Adding this manually takes a LONG time (18 fields and over 800 words), so I recommend against it. If someone wants to take a look at the dbs file, it's in this zip package. I don't want to put it on SBitz until I get this resolved.
HuwR
05 May 2009, 16:12
what errors does it report ?
Carefree
05 May 2009, 18:04
-2147217900 | Syntax error in INSERT INTO statement
Carefree
05 May 2009, 18:19
I tried changing my connection string to a DSN type, now it won't create the table. Something strange is in the neighborhood.
Carefree
05 May 2009, 18:28
Using a jet connection string, it will create the table but not insert the records. DSN won't do anything.
HuwR
06 May 2009, 01:38
you problem is possibly related to the fact you have chosen the 'single' datatype, a single type expects a floating point number and 1 is not a floating point number, so change single to int.
and to be honest rather than doing it like (WORDLIST,M_IDB2,M_JET,M_ACCS,M_ANSI,M_ODBC,M_FUTR,M_2000,M_2005,M_2008,M_MYSQ,M_OLAP,M_ORAC,M_PTGR,M_PS92,M_PS99,M_PS03,M_SYBA)#('ABS',,,,,,,,,,,,,,,,1,) I would do (WORDLIST,M_PS03)#('ABS',1)
would mike it a lot easier to handle and debug
Carefree
06 May 2009, 07:02
I tried it that way (and the database is created without error), but it doesn't have the necessary structure. Now I have multiples of numerous words and the selects cannot function.
Carefree
06 May 2009, 07:24
I fixed it. I replaced nulls with 0s and it works. Updated at SnitzBitz.
By the way, it works using either single or int.