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
SELECT * FROM Events
Run it and then go through the recordset like
RecordSet.MoveFirst
while not end of recordset
[INDENT]response.write recordset.fields(“customerid”).item[/INDENT]
[INDENT]recordset.movenext[/INDENT]
wend
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: