aa wrote:
How do I get to the fieldnames of a table in a recordset?
I have a recordset which I output into HTML.
And on data from certian columns I need to perform different actions.
I would like to use the fieldnames rather then theit sequential
numbers, to avoid the need to re-do the code if another field is
inserted into the table.
You will never have to do this if you follow the good coding practice of
always explicitly naming the columns you wish your queries to return,
instead of using "Select *". Your queries will execute faster if you do this
since you avoid an extra trip to the database which ADO needs to make when
selstar is used.
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.