This is what i have and i keep getting a type mismatch error
obviously im doin it wrong.. all i wanna do is print out the first 6 topic names.

DO UNTIL x=6
strSQL = "SELECT * FROM Topic_Questions " _
& "WHERE Topic_Number='" & Replace(x, "'", "''") & "';"
Set objRS = objConn.Execute(strSQL)
response.write(objRS("Topic_Title"))
x++
LOOP


THANKS FOR ANY HELP

TIS OK ive got it now

dont need the ' 'after the = in the strSQL.