Detect if a names field exists in a record set

mat41 · May 9th, 2013, 10:22 PM

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

Code:

    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
    next

TYIA

Imar · May 10th, 2013, 03:35 AM

Hi Matt,

The only way I know is by looping over the Fields collection as I've described here: http://imar.spaanjaars.com/262/find-...database-table

Imar

mat41 · May 13th, 2013, 12:04 AM

Hi Imar - Thank you for you time

My research/testing says its impossible without looping. For others there was an issue with my initial post. It was missing an exit for therefore would have always been false:

Code:

dim rs,field,foundField sql = "SELECT * from table;" set rs = conn.execute(sql) For Each field in rs.Fields    if field.Name = "someFieldName" then        foundField = true    exit for    else        foundField = false    end if next