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, hence 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. Is SimpleSlash still being maintained?
Simpleslash I don't think has ever been "maintained" really. I posted some code snippets which ended up being released as a mod with my name on it heh.
Hard to really say what the problem is, I'd suggest putting some response.writes in to see just whats coming back from each query.
Topic Locked
Posted - 20 October 2004 : 18:24:42
