How can I figure out SQL tables Column names with ASP?

[Arkkimaagi]

I'd like to know what column names an table has. I can see the data they contain, but not the column titles.

I can use ASP to get this information from database.

[spartan]

yes you can...

try this... (just error check, I'm writing on the fly here)

set rs = createobject("ADODB.recordset")
rs.open "select * from mytable", conn

'create a table to output column names and values
'------------------------------------------------
response.write "<TABLE><TR>"
'write column names
For each thingy in rs.fields
    response.write "<TD>" & thingy.name & "</TD>"
next
response.write "</TR>"

'write contents
while not rs.eof
    response.write "<TR>"
    For each thingy in rs.fields
       response.write "<TD>" & thingy & "</TD>"
    next
    response.write "</TR>"
    rs.movenext
wend

response.write "</TABLE>"

[MattR]

What database are you using? You may be able to run a query to get the columns from a table at will.

[Arkkimaagi]

Thank you, I got it working