Selecting field name/value

Is there a way to select the field name and the value for the fields in a row in a table?

Thx
Chuck

Sure. I don't know what tools you're using, but if you used ADO with ASP you could do something like this:

Set rs = Server.CreateObject("ADODB.Recordset")
'Create and open recordset...

do while rs.eof = false
for each f in rs.fields
Response.Write(f.name & " = " & f.value & "<BR>")
next
Response.Write("<BR>")
rs.movenext
loop
rs.close
Set rs = nothing