<cfquery name="qName" .....> select * from someTable </cfquery>
<cfoutput> #qName.columnList# </cfoutput> Joe Eugene Certified Advanced ColdFusion Developer > -----Original Message----- > From: Terry [mailto:[EMAIL PROTECTED] > Sent: Monday, March 10, 2003 9:32 PM > To: CF-Talk > Subject: How to get field names in MSAccess > > > I know this is simple, but can't remember. > > How do use a query to get list of column or field names. Using CF5.0 > > > Thanks > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
