SQL Question

Got a quick SQL/MySQL question for you.
We don’t have a database question @ Kirupa so I thought server side would be best.

Anyway when your looking for a recordset (ASP) you get the SQL statement


Run it and then go through the recordset like

while not end of recordset
[INDENT]response.write recordset.fields(“customerid”).item[/INDENT]

but does anybody know what to do if you don’t know the columns (for instance if the SQL script is fed in with a parameter so the columns will be different every time.

Any help’s great (either tips or direct me to a good site)
thanks :thumb: