quote:

---

Microsoft OLE DB Provider for SQL Server error '80040e14'

The column prefix 'robots' does not match with a table name or alias name used in the query.

/active_users.asp, line 733

---

case "logfeed.asp"
      strQuery = fQuery
      fTopic_ID = analyzeQuery(strQuery, "LOG_ID")
      'fTopic_ID = analyzeQuery(strQuery, "MEMBER_ID")
      fTopic_ID=replace(fTopic_ID,"=","")
      if fTopic_ID = "" then
        strPage = "Weblogs"
      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 = "Viewing weblog<br><a href=""logfeed.asp?" & fQuery & """>"
            else
              strPage = "Viewing weblog<br><a href=""logfeed.asp?" & fQuery & """>"
            end if
            strPage = strPage & fSubject
          else
            strOnlineLocation = fLang(strLangMOD_Ls3kAU_01330)
          end if
        end if
      end if

case "logfeed.asp"
      strQuery = fQuery
      if isNumeric(analyzeQuery(strQuery, "LOG_ID")) then
            fTopic_ID = cInt(analyzeQuery(strQuery, "LOG_ID"))
      else
            fTopic_ID=""
      end if
      'fTopic_ID = analyzeQuery(strQuery, "MEMBER_ID")