Displaying relevant field names

stroodle01 · #1 Oct 4th, 2007, 12:15

Hi there!

I would like to know whether it's possible to retrieve the field names, in order to display them in table format within a html page. I would like to dress the table with the cell data together with field names as 'headers' for each column.

Here is a snippet of what i have manages to produce. Currently, it displays all the entries that coincide with thier field names. The inly thing i wish to do now is to display the field names:

HTML: Select all

<html> 
<head> 
<title>date</title> 
</head> 
<body > 
<h3>Try It Out - Sailors Table With a Counter</b></i></font></h3> 

<p><br> 
<% 
Dim oRSeofc 
Set oRSeofc=Server.createObject("ADODB.recordset") 
oRSEOFc.Open "People", "dsn=20527796a" 
oRSeofc.MoveFirst 
response.write "<table border='1'>" 

Dim PersonCounter 
PersonCounter = 0 
Do While Not oRSeofc.EOF 
PersonCounter =PersonCounter + 1 

response.write oRSeofc.fields.item(counter).name 

Response.write "<tr><td>" & PersonCounter & "</td>" 
Response.write "<td>" & oRSeofc("PeopleNameFirst") & "</td>" 
Response.write "<td>" & oRSeofc("PeopleNameLast") & "</td>" 
Response.write "<td>" & oRSeofc("PeopleDOB") & "</td></tr>" 
oRSeofc.MoveNext 
Loop 
response.write "</table><br>" 
response.write PersonCounter & " Sailors in this list" 
%> 


</body> 
</html>

All help will be greatefully appreciated, thanx!!

Monie · #2 Oct 5th, 2007, 03:26

Do you mean displaying all data from your table database?

Monie · #3 Oct 5th, 2007, 07:11

If so, this is a great link that I found today.
It teach you step by step way in creating a simple Add, Edit, Show, Delete function in asp.

It's a great link. [ Here ]
Hope this helps you!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating a "tag" system to find relevant "related" pages	MrQuestions	PHP Forum	3	Mar 20th, 2008 23:06
Need javascript to set input field value field	jdadwilson	JavaScript Forum	3	May 9th, 2007 04:47
validate text field to db field	jtesolin	Classic ASP	1	Jul 18th, 2006 17:48
Odd input field not displaying problem	hankhill	Classic ASP	1	Jun 26th, 2006 23:11

		Webforumz.com > Main Forums > Program Your Website > Classic ASP
Displaying relevant field names