> just do a WHERE 0 = 0 This will work for the purpose of getting the schema/columns, but it brings back the entire Table Data.. because 0=0 leads to "TRUE"
The query has to lead to "False" like i suggested below. > select * from TableName where 1=0; Which leads to false and brings back NO DATA, Just schema(columns). This is not the best way to get Table metaData. You should also be able to get column data types and size limits. This is only possible with using a Java Alernative(Better) or using System Table Information. Joe Eugene > -----Original Message----- > From: Jason Miller [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 11, 2003 12:11 AM > To: CF-Talk > Subject: Re: How to get field names in MSAccess > > > just do a WHERE 0 = 0 > > I just tested it out and it works > <cfquery name="qName" datasource="#dsndata#"> > select * from ModuleFeatures > where 0 = 0 > </cfquery> > <cfoutput> > #qName.columnList# > </cfoutput> > > outputs all the columns in that table > jay miller > > > Joe Eugene wrote: > > > 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] <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] <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 > <http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4> > > Subscription: http://www.houseoffusion.com/cf_lists/index > <http://www.houseoffusion.com/cf_lists/index> . > > cfm?method=subscribe&forumid=4 > > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > <http://www.thenetprofits.co.uk/coldfusion/faq> > > Get the mailserver that powers this list at > > http://www.coolfusion.com <http://www.coolfusion.com> > > > > Unsubscribe: > > > > http://www.houseoffusion.com/cf_lists/uns > <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 > <http://www.turnkey.to> > > > > lead architect, tapestry cms http://products.turnkey.to > <http://products.turnkey.to> > > > > tapestry api is opensource http://www.turnkey.to/tapi > <http://www.turnkey.to/tapi> > > > > certified advanced coldfusion 5 developer > > http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 > <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
