Snitz Forums 2000 - Active users mod - syntax error in query expressio

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: MOD Implementation

Active users mod - syntax error in query expressio

New Topic

Topic Locked

Printer Friendly

Author

Topic

blackinwhite
Average Member

Turkey
657 Posts

Posted - 19 December 2002 : 02:37:10

Sometimes i see this error in active users page:

quote:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'TOPIC_ID==529'.

/active_users.asp, line 376

Line 376 refers to the red part below code.


	    strQuery = fQuery
        if lcase(analyzeQuery(strQuery, "ARCHIVE")) = "true" then
          strSql = "SELECT FORUM_ID, TOPIC_ID, T_SUBJECT FROM " & strTablePrefix & "A_TOPICS WHERE TOPIC_ID=" & fTopic_ID
        else
          strSql = "SELECT FORUM_ID, TOPIC_ID, T_SUBJECT FROM " & strTablePrefix & "TOPICS WHERE TOPIC_ID=" & fTopic_ID
        end if
        set rst = my_conn.execute(strSql)

an anyone know how to solve this?

laser
Advanced Member

Australia
3859 Posts

Posted - 19 December 2002 : 02:57:32

Sorry, I have seen this error before and I even think I had it myself .... the answer is certainly contained in the forums here somewhere, but I can't find it now