looping through rs

Results 1 to 2 of 2

Thread: looping through rs

  1. #1
    Join Date
    Dec 1969

    Default looping through rs

    after querying my database i want to list the results. the query works but regardless of how many records there are my loop just continues to response.write like 30 times. can someone tell me why it is doing this. the code:<BR><BR> do while not theRecordset.EOF<BR> dataB = theRecordset("Btime")<BR> dataE = theRecordset("Etime")<BR> dataN = theRecordset("Name")<BR> DCID = theRecordset("DCID") <BR> <BR> response.write "DCID: "&DCID<BR> response.write "Name: "&dataN<BR> response.write "Begin: "&dataB<BR> response.write "End: "&dataE<BR><BR> theRecordset.movenext<BR> loop<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: looping through rs

    try <BR><BR>do until rs.eof

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts