# SQL Question

**URL:** https://forum.kirupa.com/t/sql-question/123560
**Category:** Uncategorized
**Created:** [September 24, 2004, 6:57pm UTC](https://forum.kirupa.com/t/sql-question/123560 "2004-09-24T18:57:57Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![RabBell](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/rabbell/32/340_2.png) [@RabBell](https://forum.kirupa.com/u/RabBell)
#### Post date: [September 24, 2004, 6:57pm UTC](https://forum.kirupa.com/t/sql-question/123560/1 "2004-09-24T18:57:57Z")

</div>

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: