Today I made a post to one forum and immediately got an error on the page where I use SimpleSlash. Error was about closing a non-existant object, but I tracked it down to this line:
While Not objRS.EOF
strSQL = "SELECT COUNT(*) FROM FORUM_REPLY WHERE TOPIC_ID = " & objRS("TOPIC_ID")
Set objRS2 = objConn.Execute(strSQL)
After commenting out this line, I discovered the original query is not returning any records, so objRS.EOF is true.
I haven't made any changes to SimpleSlash recently, so it looks like this happened because of a post. However, if I run the original strSQL directly on my database, I also get no records.
Any clues? Let me know if you want me to post the sql query.
Topic Locked
Posted - 12 October 2004 : 12:03:26
