Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: looping through rs


Message #1 by "Tim Lyons" <lyno@h...> on Thu, 11 Jul 2002 16:41:22
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

  Return to Index