Snitz Forums 2000 - Syntax error - 80040e14 w/Poll MOD

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: MOD Implementation

Syntax error - 80040e14 w/Poll MOD

New Topic

Topic Locked

Printer Friendly

Author

Topic

tomasalsbro
Average Member

Sweden
818 Posts

Posted - 02 July 2001 : 06:09:29

Hi,
I recieved this message
==================
Microsoft JET Database Engine error '80040e14'

Syntax error (missing operator) in query expression 'FORUM_TOPICS.answer20 WHERE FORUM_TOPICS.TOPIC_ID = 212'.

/forum/post.asp, line 367
===============
Line 367 in post.asp: set rs = my_Conn.Execute (strSql)
The file - post.txt - is here
Can anyone help me?
Cheers / Tomas

!-Keep distance in traffic-!
www.whiplash.pp.se

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 02 July 2001 : 10:11:27

After line 363 put this code:

strSql = strSql & " FROM " & strTablePrefix & "TOPICS "

Then you will have this:

strSql = "SELECT " & strTablePrefix & "TOPICS.CAT_ID, " & strTablePrefix & "TOPICS.FORUM_ID, " ...
strSql = strSql & " FROM " & strTablePrefix & "TOPICS "
strSql = strSql & " WHERE " & strTablePrefix & "TOPICS.TOPIC_ID = " & Request.QueryString("TOPIC_ID")

- David

tomasalsbro
Average Member

Sweden
818 Posts

Posted - 02 July 2001 : 10:45:36

Hi Davio!

It worked perfect! Thank you so much.
Tomas

!-Keep distance in traffic-!
www.whiplash.pp.se

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.33 seconds.