Hi all,
i had an error on this file.
active_topics.asp
when i click on ( active topics ) button , it's give this error:
error '80004005'
Unspecified error
/forum/active_topics.asp, line 265
and when i check it, the error is in this code statement:
*******************************************
strSQL = "SELECT tblForum.Forum_name, tblForum.Password, tblForum.Forum_code, tblForum.[Read], tblTopic.* "
strSQL = strSQL & "FROM tblCategory, tblForum, tblTopic "
strSQL = strSQL & "WHERE ((tblCategory.Cat_ID = tblForum.Cat_ID AND tblForum.Forum_ID = tblTopic.Forum_ID) AND (tblForum.Read = True) AND (tblTopic.Last_entry_date > " & strDatabaseDateFunction & " - " & dblActiveFrom & "))"
strSQL = strSQL & "ORDER BY tblCategory.Cat_order ASC, tblForum.Forum_Order ASC, tblTopic.Last_entry_date DESC;"
End If
rsForum.Open strSQL, adoCon
********************************************
can anybody tell me why it's give me errror
plzz