Hello classic ASP world, hopefully there are still a few of us around...
Does anybody know how to check if a named field is within a record set?
EG id, field1, field2, field3 have been selected. Is it possible for VBScript to detect if field2 has been selected..
Please assume I dont know, nor can see the actual SELECT. I need to detect this after the query has been executed.
How to do it while looping, BUT I am also hoping this is possible without looping
sql = "SELECT * from tableName;"
set rs = conn.execute(sql)
For Each field in rs.Fields
if field.Name = "lookinForFieldName" then foundField = true else foundField = false