Return # of Fields in sql query 1

[AgentM]

Is there a way to retrieve the number of fields in a sql query or the table fields from a sql query

 

[jitter]

Sure, if all you need is the number of fields you can just use:


objRS.Fields.Count


for other information you could loop through and get the information. Here is a small example:


For Each Field In ObjRS.Fields
Response.Write Field.Name & &quot;<br>&quot;
Next


This will give you the name of each field in the recordset. Hope this helps.....