Need Select Statement To Return Multiple Rows

[kwil38]

I've got a select statement in a .asp page which retrieve information from a view. In some cases, the query will return more than 1 row. When this happens, I need to read all of the rows returned, not just the first row. How can I do this?

Thanks!

 

[DotNetGnat]

how are you displaying your recordset...

you need to loop through all your recordset to display all the values...

may be using something like...

do until rs.EOF
'write you data here
rs.Movenext
loop


-DNG

 

[kwil38]

Yes, that's exactly what I needed. Thanks DNG!