Sometimes when I check my active users page i get the following error:
Microsoft OLE DB Provider for SQL Server error '80040e14'
Line 1: Incorrect syntax near '='.
/active_users.asp, line 379
This only happens on some occasions. Most of the time it looks good.
Here is a picture of the error, and how the page looks:
(The line marked below is line 379)
strPage = fLang(strLangMOD_Ls3kAU_01300)
end if
end if
end if
case "topic.asp"
strQuery = fQuery
fTopic_ID = analyzeQuery(strQuery, "TOPIC_ID")
if fTopic_ID = "" then
strPage = fLang(strLangMOD_Ls3kAU_01270)
else
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)
if rst.EOF or rst.BOF then
strPage = fLang(strLangMOD_Ls3kAU_01270)
else
fSubject = rst("T_SUBJECT")
fForum_ID = rst("FORUM_ID")
rst.close
set rst = nothing
if chkForumAccess(fForum_ID, MemberID, false) then
strQuery = fQuery
if lcase(analyzeQuery(strQuery, "ARCHIVE")) = "true" then
strPage = fLang(strLangMOD_Ls3kAU_01310) & "<br><a href=""topic.asp?" & fQuery & """>"
else
strPage = fLang(strLangMOD_Ls3kAU_01320) & "<br><a href=""topic.asp?" & fQuery & """>"
end if
strPage = strPage & fSubject
else
strOnlineLocation = fLang(strLangMOD_Ls3kAU_01330)
Please help out with this