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.
On 7/31/06, Terry C. Mergl <[EMAIL PROTECTED]> wrote:
> I'll give it a whirl.
>
>
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> 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: Tom Chiverton [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 31, 2006 10:44 AM
> To: CF-Talk
> Subject: Re: Oracle 8.i and querying for table/field list
>
> On Monday 31 July 2006 15:31, Terry C. Mergl wrote:
> > <cfquery datasource="alopa" username="metaserv" password="metaserv"
> > name="findfields">
> > Select * From #i#
> > </cfquery>
>
> <guess>One of the tables is huge. Try count(*) instead.</guess>
>
> --
> Tom Chiverton
>
> ****************************************************
>
> This email is sent for and on behalf of Halliwells LLP.
>
> Halliwells LLP is a limited liability partnership registered in England and
> Wales under registered number OC307980 whose registered office address is at
> St James's Court Brown Street Manchester M2 2JF. A list of members is
> available for inspection at the registered office. Any reference to a
> partner in relation to Halliwells LLP means a member of Halliwells LLP.
> Regulated by the Law Society.
>
> CONFIDENTIALITY
>
> This email is intended only for the use of the addressee named above and may
> be confidential or legally privileged. If you are not the addressee you
> must not read it and must not use any information contained in nor copy it
> nor inform any person other than Halliwells LLP or the addressee of its
> existence or contents. If you have received this email in error please
> delete it and notify Halliwells LLP IT Department on 0870 365 8008.
>
> For more information about Halliwells LLP visit www.halliwells.com.
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:248235
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
