Database Discussion - Field name/column name

Print Page | Close Window

Field name/column name - Access DB

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=24700
Printed Date: 29 March 2026 at 3:06pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Field name/column name - Access DB

Posted By: webpromo
Subject: Field name/column name - Access DB
Date Posted: 26 October 2007 at 2:53pm

Is there a way to display the field name/column names from an Access database using ASP?

Replies:

Posted By: shakir
Date Posted: 02 December 2007 at 4:30pm

For Each Item in Request.Form
Response.Write Request.Form.Key(Item) & ": " & Response.Write Request.Form.Item(Item) Next

Posted By: Jono
Date Posted: 03 December 2007 at 8:19pm

shakir's almost right, but he's given you the code to iterate through variables passed to a web page via the GET or POST method - a useful piece of code, nonetheless.

This web page should provide you with a snipet of code that should help: http://www.w3schools.com/ado/ado_display.asp - http://www.w3schools.com/ado/ado_display.asp

As you can see, you have to specify the table you want to display from the database. If you want to get more adventurous, you could combine this with code obtaining a list of table from the acess database, so you just link to the database and it will return all tables, with field names from each table.