after querying the database, i am just trying to see what was gathered so 
i loop through the rs as so:

	do while not theRecordset.EOF
		dataB = theRecordset("Btime")
		dataE = theRecordset("Etime")
		dataN = theRecordset("Name")
		DCID = theRecordset("DCID")

		response.write "<br>DCID: "&DCID&"<br>"
		response.write "Name: "&dataN&"<br>"
		response.write "Begin: "&dataB&"<br>"
		response.write "End: "&dataE&"<br><br>"
	theRecordset.movenext
	loop

for some reason the same thing is written out over and over again like 
thirty times. regardless if there are 1, 2, or 3 entries. what am i doing 
wrong here?

TL

Maybe you have the same thing over and over in the recordset. What is the
query that you are using to generate the recordset?

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "lyno" <lyno@h...>
Subject: [access_asp] looping through the rs


: after querying the database, i am just trying to see what was gathered so
: i loop through the rs as so:
:
: do while not theRecordset.EOF
: dataB = theRecordset("Btime")
: dataE = theRecordset("Etime")
: dataN = theRecordset("Name")
: DCID = theRecordset("DCID")
:
: response.write "<br>DCID: "&DCID&"<br>"
: response.write "Name: "&dataN&"<br>"
: response.write "Begin: "&dataB&"<br>"
: response.write "End: "&dataE&"<br><br>"
: theRecordset.movenext
: loop
:
: for some reason the same thing is written out over and over again like
: thirty times. regardless if there are 1, 2, or 3 entries. what am i doing
: wrong here?