Display all from an SQL query

[davejam]

A little simple one, can't remember the syntax to display on the screen all the results from an sql statement.

response.write recordset.*

Obviously this doesn't work but its what i mean!

Help!!

Cheers

DaveJam
**Getting the right answers is the easy part, matching it to the question is the problem!**

 

[simonchristieis]

i believe the object is rs.fields

 

[Bullschmidt]

How about something like this:

For Each objFld In objRS.Fields
Response.Write objFld.Name & ": "
Response.Write objFld.Value & &quot;<br>&quot;
Next


Best regards,
J. Paul Schmidt, Freelance ASP Web Developer

http://www.Bullschmidt.com

ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...