accessing the field header

liunx

Guest
I have this to access the fields inside my database.<br />
<br />
If Not objCleanUpRS.EOF Then<br />
objCleanUpRS.MoveFirst<br />
'Show data<br />
Do While Not objCleanUpRS.EOF<br />
Response.Write "<tr>" & vbCrLf<br />
For I = 0 To objCleanUpRS.Fields.Count - 1<br />
Response.Write vbTab & vbTab & "<td>" & objCleanUpRS.Fields(I) & "</td>" & vbCrLf<br />
Next<br />
Response.Write vbTab & "</tr>" & vbCrLf<br />
objCleanUpRS.MoveNext<br />
Loop<br />
End If<br />
Response.Write "</table>" & vbCrLf<br />
<br />
this will print out the two records in my database<br />
02/02/2003 James<br />
02/03/2003 Mike<br />
<br />
I want to access the header name.<br />
I need to know the keywords to access<br />
Date Name<br />
<br />
this access the field<br />
objCleanUpRS.Fields(I) <br />
what word access the header (I'm not sure that header is the right word to for it but basically it is the name of what is in the field)<!--content-->Yeah I figured it out!!!!!!!!!!!!!!!!!<br />
objCleanUpRS.Fields(I).Name<br />
will access the name of the field.<!--content-->
 
Back
Top