-
ADO recordset
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
-
rsRecordset.Fields.Count
Ian :)
-
recordsetobject.fields.count
-
duhh... i'm just about to shoot my self in the head.... my brain isnt the best atm
but thanx anyway