Passing recordset value to a query

Please Help!!!!!

I've been trying to figure this out for a couple of days to no avail.

I'm trying to pass a value that I get from one database query (stored in the recordset. To another database query, and I'm getting an error stating that there is a type mismatch. Here is the code. Specifically I'm trying to pass the value of ThreadID that I get from the first query (always returns a single value) storing it in a variabel called ThreadReply, and then using that variable in my second query statement.

set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT ThreadID FROM TblForumThread WHERE ThreadName='"&Session("ThreadName")&"';"
rs.Open sql, conn
ThreadReply=rs("ThreadID")
rs.Close
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT * FROM TblForumReply WHERE ThreadID='"&ThreadReply&"';"
rs.Open sql, conn

Please Help.

try it this way and see if if helps. i had this same problem a long time ago but i am not sure if this was right for a fix or not :

Thank You
for your quick response. Unfortunately it did not work, is there anything else that I can try.

Thanx

if ThreadID is a numeric field in the database then do not enclose the value in single quotes.

That worked!!!

Thank You very much