Classic ASP Discussion - SELECT only brings back first record

Print Page | Close Window

SELECT only brings back first record

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=9323
Printed Date: 01 April 2026 at 1:00am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SELECT only brings back first record

Posted By: kokopoko
Subject: SELECT only brings back first record
Date Posted: 28 January 2004 at 12:43pm

My select statement only brings back the first record in the table. The table does contain more than one record.

SELECT answer1 FROM lpdaacsurvey

Any ideas as to why it's only bringing back the first record?

Replies:

Posted By: Semikolon
Date Posted: 28 January 2004 at 1:02pm

you have to move to the next record in a loop like this

do while not rs.eof

response.write(rs("field"))

rs.movenext

loop

Posted By: pmormr
Date Posted: 28 January 2004 at 7:18pm

w3schools.com has some good tutorials on ADO with asp... go to www.w3schools.com click on ASP and then click on LEARN ADO

-------------
Paul A Morgan

http://www.pmorganphoto.com/" rel="nofollow - http://www.pmorganphoto.com/