| T O P I C R E V I E W |
| Carefree |
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.< |
| 12 L A T E S T R E P L I E S (Newest First) |
| Carefree |
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. |
| Carefree |
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. |
| HuwR |
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 |
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. |
| Carefree |
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. |
| Carefree |
Posted - 05 May 2009 : 18:04:03
-2147217900 | Syntax error in INSERT INTO statement |
| HuwR |
Posted - 05 May 2009 : 16:12:32
what errors does it report ? |
| Carefree |
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. |
| MarcelG |
Posted - 09 January 2009 : 07:23:23
Ah, so just a reference page. That makes indeed sense. Thanks.< |
| AnonJr |
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.< |
| HuwR |
Posted - 08 January 2009 : 10:06:21
it just gives you a list of restricted keywords in various flavours of SQL, not sure why.
< |
| MarcelG |
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?< |
|
|
