It's guaranteed to bring back 0 records, giving you just the query columns.
By the way, if that's your real username and password, you should probably change them, because now the entire world knows it. -----Original Message----- From: Terry C. Mergl [mailto:[EMAIL PROTECTED] Sent: Monday, July 31, 2006 11:08 AM To: CF-Talk Subject: RE: Oracle 8.i and querying for table/field list James, not sure what to say but that did it. It listed all of the tables and fiellds and fast also. I appreciate it very very much. Terry PS: Why WHERE 0=1 though? -----Original Message----- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Monday, July 31, 2006 10:59 AM To: CF-Talk Subject: Re: Oracle 8.i and querying for table/field list Try this <cfquery datasource="alopa" username="metaserv" password="metaserv" name="findfields"> Select * From #i# WHERE 0=1 </cfquery> Yes, I did type that correctly. The fieldnames should still be returned, even though the recordcount is 0. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248241 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
