The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
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.<
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.<
Posted
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?<
portfolio - linkshrinker - oxle - twitter
Last edited by MarcelG on 08 January 2009, 09:15
Posted
it just gives you a list of restricted keywords in various flavours of SQL, not sure why.
<
<
Posted
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
Ah, so just a reference page. That makes indeed sense. Thanks.<
portfolio - linkshrinker - oxle - twitter
Posted
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.
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.
Last edited by Carefree on 05 May 2009, 15:20
Posted
what errors does it report ?
Posted
-2147217900 | Syntax error in INSERT INTO statement
Posted
I tried changing my connection string to a DSN type, now it won't create the table. Something strange is in the neighborhood.
Last edited by Carefree on 05 May 2009, 18:28
Posted
Using a jet connection string, it will create the table but not insert the records. DSN won't do anything.
Posted
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
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
Email Member
Message Member
Post Moderation
FileUpload
If you're having problems uploading, try choosing a smaller image.
Preview post
Send Topic
Loading...