> If you don't want to select any data, and just want the column names, use > or where myprimarykey = #somevalueiknowwontexistinthetable#
What happens.. if you dont have a primary key? out of luck? select * from TableName where 1=0; Joe Eugene > -----Original Message----- > From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] > Sent: Monday, March 10, 2003 10:25 PM > To: CF-Talk > Subject: RE: How to get field names in MSAccess > > > 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4