Getting Column Names

Results 1 to 2 of 2

Thread: Getting Column Names

  1. #1
    Join Date
    Dec 1969

    Default Getting Column Names

    Is there a way to get column names programatically using ASP? My stored procedure uses pivot tables, and the names of the columsns could theoretically be different every time the query is run. Is there a way to get column names from a recordset? Thanks!

  2. #2
    Join Date
    Dec 1969

    Default RE: Getting Column Names

    sure, use the ADO fields .name property on the returned recordset, something like:<BR><BR>&#060;%<BR>For Each Fld In rs.Fields<BR> Response.write Fld.Name<BR>Next<BR>%&#062;<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts