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.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net