Help on simple SQL issue

What's wrong with my SQL here?

I want to retrieve a specific (pre-known) post from the WWF7 db.

strSQL = "SELECT TOP 1 Thread_ID, Topic_ID, Message, Message_date FROM "
strSQL = strSQL & "tblThread WHERE "
strSQL = strSQL & "Topic_ID = 128 " 
strSQL = strSQL & "Thread_ID = 391"
strSQL = strSQL & " ORDER BY Message_date DESC"
Set rsThreads = connectForum.Execute(strSQL)

I always get the same (wrong) post from Topic_ID = 128, namely the last one posted. Even if I change the last SQL-line to ORDER BY Message_date ASC the result is the same.

I'd really appriciate any suggestions!

Chris

strSQL = strSQL & " AND Thread_ID = 391"

Theres no way your posted SQL script should have worked, the above should

and if it doesn't, then Response.Write (and Response.End right after that) out the variable holding the script and confirm its correct

Thanks!

But when I display the Message an annoying tag is attached to it, like User234234,2342525622231. How do I get rid of that?

I now use
strMessage = rsThreads.Fields("Message").Value

for putting the Message in variable strMessage and

Response.Write(vbCrLf & strMessage & vbCrLf)

for displaying it. Any other (better) suggestions?

Chris

Nope, that doesn't make the trick. The trace of the user who posted the message seem to be smuggled into strMessage anyway, a really ugly string like User312331,312512512312

There must be an evil Ghost inside my machine...  

Chris