PCMech Forums - View Single Post - ASP

UncaDanno · 01-17-2001, 09:50 PM

So, are you executing the SQL string by opening a recordset? Something like:

Set rsTickets = connTicketConn.execute strSQL ?

If so, you build a loop:

Code:

While not rsTickets.EOF
    Response.Write "<TR><TD>" & rsTickets("Opened_By") & _
         "</TD><TD>" &amp rsTickets("intTickets") &amp "</TD></TR>"
    rsTickets.MoveNext
Loop

Or am I way out in left field?

[Edited by UncaDanno on 01-17-2001 at 10:53 PM]

01-17-2001, 09:50 PM	#8
UncaDanno Member (9 bit) Join Date: Dec 1999 Location: Midland, NC, USA Posts: 292	So, are you executing the SQL string by opening a recordset? Something like: Set rsTickets = connTicketConn.execute strSQL ? If so, you build a loop: Code: While not rsTickets.EOF Response.Write "<TR><TD>" & rsTickets("Opened_By") & _ "</TD><TD>" &amp rsTickets("intTickets") &amp "</TD></TR>" rsTickets.MoveNext Loop Or am I way out in left field? [Edited by UncaDanno on 01-17-2001 at 10:53 PM]