If you don't want to select any data, and just want the column names, use
<cfquery name="qName" .....>
select * from someTable
where myprimarykey is null
</cfquery>
or where myprimarykey = #somevalueiknowwontexistinthetable#
> <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/uns
> ubscribe.cfm?user=633.558.4
s. isaac dealey 954-776-0046
new epoch http://www.turnkey.to
lead architect, tapestry cms http://products.turnkey.to
tapestry api is opensource http://www.turnkey.to/tapi
certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
