| Author |
 Topic  |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
 Posted - 15 December 2008 : 01:54:41
|
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.< |
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
Posted - 08 January 2009 : 09:15:41
|
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 |
Edited by - MarcelG on 08 January 2009 09:15:56 |
 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 08 January 2009 : 10:06:21
|
it just gives you a list of restricted keywords in various flavours of SQL, not sure why.
< |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 08 January 2009 : 10:54:23
|
| 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
Retired Support Moderator
Netherlands
2625 Posts |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 05 May 2009 : 15:17:26
|
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. |
Edited by - Carefree on 05 May 2009 15:20:39 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 05 May 2009 : 16:12:32
|
| what errors does it report ? |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 05 May 2009 : 18:04:03
|
| -2147217900 | Syntax error in INSERT INTO statement |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 05 May 2009 : 18:19:51
|
| I tried changing my connection string to a DSN type, now it won't create the table. Something strange is in the neighborhood. |
Edited by - Carefree on 05 May 2009 18:28:46 |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 05 May 2009 : 18:28:30
|
| Using a jet connection string, it will create the table but not insert the records. DSN won't do anything. |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 06 May 2009 : 01:38:27
|
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
Advanced Member
Philippines
4207 Posts |
Posted - 06 May 2009 : 07:02:30
|
| 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
Advanced Member
Philippines
4207 Posts |
Posted - 06 May 2009 : 07:24:34
|
I fixed it. I replaced nulls with 0s and it works. Updated at SnitzBitz.
By the way, it works using either single or int. |
Edited by - Carefree on 06 May 2009 07:46:55 |
|
|
| |
Topic |
|
Restricted Keywords Mod
