View Single Post
 
Old May 13th, 2013, 12:04 AM
mat41 mat41 is offline
Friend of Wrox
Points: 6,664, Level: 34
Points: 6,664, Level: 34 Points: 6,664, Level: 34 Points: 6,664, Level: 34
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2004
Location: Sydney, NSW, Australia.
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

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
__________________
Wind is your friend
Matt