I have the pm mod running smoothly, but when i added the pager part. i wanted to have a more instant pm system. i get this error
Error Type: Microsoft JET Database Engine (0x80040E37) The Microsoft Jet database engine cannot find the input table or query 'FORUM_ONLINE'. Make sure it exists and that its name is spelled correctly. /ssite/aspforum/pm_pop_pager.asp, line 50
I added the db peices it asked for in the pm, and cna't figure out what's wrong.
this is what's in line 50 <% ' Get Guest count for display on Default.asp set rsGuests = Server.CreateObject("ADODB.Recordset")
if strDBType = "access" then strSqL = "SELECT count(UserID) AS [Guests] " else strSqL = "SELECT count(UserID) Guests " end if strSql = strSql & "FROM " & strTablePrefix & "ONLINE " strSql = strSql & " WHERE Right(UserID, 5) = 'Guest' "
Topic Locked
Posted - 04 June 2002 : 05:58:18
