Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Current Version (Old)
 i get a error when i go onto the send page...
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

MaD2ko0l
Senior Member

United Kingdom
1053 Posts

Posted - 05 December 2001 :  15:01:14  Show Profile  Visit MaD2ko0l's Homepage
i get a error when i go onto the send page of my forum, this is the error i get


Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'FORUM_REPLY.R_DATE LIMIT 18'.

/forum/topic.asp, line 278


can anyone hlep me plz???

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 05 December 2001 :  15:12:52  Show Profile
Make sure you have only uncommented 1 of the strDBType lines in your config.asp page.

it should look like this if you are using an Access DB:

'#################################################################################
'## SELECT YOUR DATABASE TYPE AND CONNECTION TYPE (access, sqlserver or mysql)
'#################################################################################
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
Go to Top of Page

MaD2ko0l
Senior Member

United Kingdom
1053 Posts

Posted - 06 December 2001 :  11:18:43  Show Profile  Visit MaD2ko0l's Homepage
ok but that is what it is at i think.

got anymore help?

Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 06 December 2001 :  13:02:51  Show Profile
Please check to make sure.
Also can you post a link to a txt version of your topic.asp file.

- David
Go to Top of Page

MaD2ko0l
Senior Member

United Kingdom
1053 Posts

Posted - 06 December 2001 :  15:02:01  Show Profile  Visit MaD2ko0l's Homepage
uumm i think that i fixed it and who do u want a txt version of my topic.asp file???

Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 06 December 2001 :  21:56:05  Show Profile
so I can take a look at your file and see what line is 278.
But since you have fixed it I don't need to look at it.

It would be helpful though if you posted how you fixed your problem in case someone else runs into the same problem.

- David
Go to Top of Page

MaD2ko0l
Senior Member

United Kingdom
1053 Posts

Posted - 09 December 2001 :  17:10:08  Show Profile  Visit MaD2ko0l's Homepage
well ok...what ui done was i had something commented that wasnt meant to be commented.

hehe silly me
Thankx 4 the help

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.24 seconds. Powered By: Snitz Forums 2000 Version 3.4.07