Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is there a way...

Status
Not open for further replies.

sbishops

Programmer
Dec 16, 2003
14
0
0
US
Is there a way to dynamically get a column name from an access 2000 db in asp, using vbscript?

Like a COL_NAME function or something?????

THANKS IN ADVANCE
 
thread333-735372

_____________________________________________________________________
onpnt2.gif
[sub]
Hakuna matata!!
[/sub]
 
create a recordset named "rs" then . . .

dim Field
Response.Write(&quot;<table><tr>&quot;)
for each Field in rs.fields
Response.Write(&quot;<td><b>&quot; & Field.name & &quot;</b></td>&quot;)
next
Response.Write(&quot;</tr>&quot;)
do while not rs.eof
Response.Write(&quot;<tr>&quot;)
for each Field in rs.fields
Response.Write(&quot;<td>&quot; & rs(Field.name) & &quot;&nbsp;</td>&quot;)
next
Response.Write(&quot;</tr>&quot;)
rs.MoveNext
loop
Response.Write(&quot;</table>&quot;)

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top