Server is private on a non routable network. Password changed though. Brutal mistake on my part.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Terry C. Mergl - MCSE, CNA, WCSPV Darien Telephone Co. 1011 North Way Darien, GA 31305 912-437-6677 voice 912-270-0505 mobile [EMAIL PROTECTED] Network Administrator ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ This e-mail message and any attachments may be confidential, proprietary or privileged information. If you are not the intended recipient, or a person responsible for delivering it to an intended recipient, any unauthorized review, disclosure, use or distribution is prohibited. If you are an unintended recipient, please delete this information from your computer and contact Darien Telephone Co., immediately by replying to this message or by sending e-mail to [EMAIL PROTECTED] Thank you. -----Original Message----- From: Everett, Al (NIH/NIGMS) [C] [mailto:[EMAIL PROTECTED] Sent: Monday, July 31, 2006 11:17 AM To: CF-Talk Subject: RE: Oracle 8.i and querying for table/field list 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:248257 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4