Getting empty recordset for a particular column during code run

Question

Hi,

I am using an Inline SQL statement Select * from table where column='' in classic asp application. This is a dynamic sql. Based on the return values in the recordset I am displaying some fields like checkboxes and text boxes. But this is working only if I put a breakpoint in specific / anywhere in the code file. while the code is running without any breakpoints actual results is not coming out.

Answer 1

Make sure that you use:

your_record_set_name.moveNext

Otherwise you won't be able to fetch any records.

Answer 2

What is the value of the Response.Buffer ?

Try setting this at the top of your asp page.

<%  Response.Buffer = True  %>

And you do have

<%  Option Explicit %>

at the top of your page, no ? Just to make sure you made no typo's somewhere in your code.