Is there a property in ASP to get every column from a table. I know that in Cold Fusion the property is : #queryname.columnlist#<BR><BR>Thanks
You mean the heading names? Or what?
Every field name from that table !!
Do you know what I mean.... I want to return every field for that table ??
This ADO ref will tell you what you need....<BR><BR>http://www.devguru.com/Technologies/ado/quickref/field.html<BR><BR>Check out the fieldobject.Name property
...determines the answer to yours.<BR><BR>Different RDBMS have different system table names and stored procedures for retrieving all kinds of database information including columns names in specific tables.<BR><BR>So, what database are you using?
Why didn't ya just say so?<BR><BR>for field = 0 to objRec.fields.count - 1<BR> response.write objRec(field).name<BR>next<BR><BR>That should do it...
If so, then the system tables sysobjects and syscolumns will give you an enormous amount of detail about your table and it's columns. The ID column in these two tables is the relational key.