Restricted Keywords Mod

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. dead 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.
© 2000-2021 Snitz™ Communications