ADO recordset

[beasty1711]

i have fired my vb syntax to SQL and got the results back as a recordset.

without having to run a loop is there anyway of checking how many columns there are in the data that is returened/

i.e if tTable as Name and age cols

then "select * from tTable" would bring back the records within that table, but i need to know that there are two cols... name and age

[Ianpbaker]

rsRecordset.Fields.Count

Ian

[barendburger]

recordsetobject.fields.count

[beasty1711]

duhh... i'm just about to shoot my self in the head.... my brain isnt the best atm

but thanx anyway