cfquery returns 3 'special' vars in addition to the actual database values.
1) queryname.columnlist - comma delimited list of column names
2) queryname.recordcount - the number of records returned from the query
3) queryname.currentrow - when cfoutputting over a query, the row currently being output.
charlie
----- Original Message -----
From: Angel Stewart
To: CF-Talk
Sent: Thursday, October 02, 2003 7:47 AM
Subject: RE: How do I tell what fields are in my tables...
Where'd you find that out?
I've been looking through CFWACK for the CFQUERY tag, and I can't find
anything that mentions the columnlist variable for CFQuery.
Is there also some other variable that stores field type?
-Gel
-----Original Message-----
From: Shawn Regan [mailto:[EMAIL PROTECTED]
you can use this: <cfoutput>#yourQuery.columnlist#</cfouput>
that will dump a list of your fields.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
