No Cerveza... No Trabajo
Join Date: Jun 2002
Location: Where's my beer?
not sure from your post what you want, but here is a stab at it:
' fieldEl.Name -> Field Name
' fieldEl.Value -> Field Content
strDSN = "Some DSN String"
strSQL = "Some SQL Query"
set con = Server.CreateObject("ADODB.Connection")
'''''' skipping the error checking on connection open
set rs = Server.CreateObject("ADODB.Recordset")
rs.Open strSQL, con
'''''' skipping the error checking on recordset retrieval
for each fieldEl in rs.fields
Response.Write "Field Name: " & fieldEl.Name & " - Field Value: " & fieldEl.Value
There isn't anything called a "Fields" object. Fields is a dictionary object that resides inside a recordset.