how to debug in asp ?

[Kim]

Im generally new to ASP, so bear with me. This is not ASP (dot) NET.

I have a query which gives results when doing the it directly, but
none (maybe) when done in asp. "Maybe" because I can not get the query
to output anything.

sample code:
set results = conn.execute("Select field1, field2, field3 from tbl")

while results.EOF
response.write("before ")
response.write(results("field1"))
response.write(" after<br>")
response.end

results.movenext
wend

sample code result:
"before after"

sample code expected result:
"before <field1_valueafter"

How can I debug this ?
I know the query is correct, and it gives results when running it
directly.