Qeury MSSQL database and get the field names

[skurpyun]

If this is not the correct forum to post this question in, forgive me.

Here is my problem. I want to query an MsSQL database and manipulate the data returned. When this data is printed to the screen, i need to match it up with its respective field (column) name. The catch is, the table's column names will change regularly in the near future.

So basically, what I want to find out is, how do i query a database and find out the field (column) names of the data returned?

-sk

 

[palbano]

>> The catch is, the table's column names will change
>> regularly in the near future.

That's just not right

Anyway, look at the ADODB SDK it's something like

Recordset.fields(n).name

-pete

 

[skurpyun]

Ok, my apologies, after playing around with my code i figured out how to do it. basically, I query the database, get the resultset, then I loop through the field collection. For each field in the field collection, i simply print it's name. So simply i had to laugh at myself for not knowing this. Here's the code:

sql = "select * from myDatabase where id=4"

set rs = connectionobj.execute(sql)

if not rs.eof

  for each fieldobj in rs.fields
     response.write fieldobj.name & &quot;<br>&quot; 'print the field name.
  next   

end if

rs.close
set rs = nothing

note: i left out all the database connection stuff, etc.

if you read this to offer your help, thanks. And if you have a better way of doing this, by all means let me know.

 

[skurpyun]

Palbano,

I understand your concern. I have the same concerns. But the table is basically to track various sites owned by a client. They are continually adding sites. And working with the database schema i inherited, I had to figure out a way to get the field names, in case a new site is added. At a later point I intend to redo the database in a more efficient way. But that requires time that I nor the client have right now!

-sk

 

[DreXor]

if not RS.eof then
for each field in rs.fields
response.write "stuff" & field.name & "more stuff" ' use this for your ... say table headers
Next
do while not rs.eof
for each field in rs.fields
response.write "stuff" & RS(field.name) & "more stuff" ' use this for outputting the values of the ever changing field names
Next
RS.MoveNext
Loop
End if