Hi everybody, hope someone can help me. I was just wondering if it is 

possible to write some sort of query in SQL in an ASP page to store the 

field names of any table in a database. It must work for any table in the 

database. Can someone please show me an example of such a query.



Thanks,

Eimear

rs.Source = "SELECT * FROM <table_name>"

for earch x in rs.Fields

	Response.Write x.Name

next 

rs.close



probably could make this quite a bit more efficient, but I'll leave that to

you... just giving you the idea

-----Original Message-----

From: eimear flynn [mailto:flynneimear@h...]

Sent: Wednesday, March 13, 2002 7:29 AM

To: ASP Web HowTo

Subject: [asp_web_howto] Query to store database table field names





Hi everybody, hope someone can help me. I was just wondering if it is 

possible to write some sort of query in SQL in an ASP page to store the 

field names of any table in a database. It must work for any table in the 

database. Can someone please show me an example of such a query.



Thanks,

Eimear




$subst('Email.Unsub').

Thanks for your help,

Eimear