Restricted Keywords Mod - Posted (2336 Views)
Advanced Member
Carefree
Posts: 4224
4224
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.<
 Sort direction, for dates DESC means newest first  
 Page size 
Posted
Retired Support Moderator
MarcelG
Posts: 2625
2625
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?<
Posted
Forum Admin
HuwR
Posts: 20611
20611
it just gives you a list of restricted keywords in various flavours of SQL, not sure why.
<
Posted
Forum Moderator
AnonJr
Posts: 5768
5768
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.<
Posted
Retired Support Moderator
MarcelG
Posts: 2625
2625
Ah, so just a reference page. That makes indeed sense. Thanks.<
Posted
Advanced Member
Carefree
Posts: 4224
4224
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.
Posted
Forum Admin
HuwR
Posts: 20611
20611
what errors does it report ?
Posted
Advanced Member
Carefree
Posts: 4224
4224
-2147217900 | Syntax error in INSERT INTO statement
Posted
Advanced Member
Carefree
Posts: 4224
4224
I tried changing my connection string to a DSN type, now it won't create the table. Something strange is in the neighborhood.
Posted
Advanced Member
Carefree
Posts: 4224
4224
Using a jet connection string, it will create the table but not insert the records. DSN won't do anything.
Posted
Forum Admin
HuwR
Posts: 20611
20611
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
You Must enter a message