Is it possible you just have too many tables for CF to query in the
timeout given? If so, you might want to up the timeout using:
<cfsetting requesttimeout="XXX">
where XXX = time in seconds.
Mingo.
Terry C. Mergl wrote:
> Hi James: here is what I have.
>
> <cfquery datasource="alopa" username="metaserv" password="metaserv"
> name="getPI">
> SELECT object_name FROM user_objects WHERE object_type in ('TABLE',
> 'VIEW')
> </cfquery>
>
> <cfset tblname=#ValueList(getPI.object_name,",")#>
>
> <cfoutput>
> <table>
> <cfloop index="i" list="#tblname#" delimiters=",">
> <cfquery datasource="alopa" username="metaserv" password="metaserv"
> name="findfields">
> Select * From #i#
> </cfquery>
> <cfset flist=#findfields.columnlist#>
> <tr><td>#i#</td></tr>
> <tr><td>#flist#</td></tr>
> <tr><td> </td></tr>
> </cfloop>
> </table>
> </cfoutput>
>
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> 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: James Holmes [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 31, 2006 10:27 AM
> To: CF-Talk
> Subject: Re: Oracle 8.i and querying for table/field list
>
> Can you post the SQL you are using to list the fields?
>
> On 7/31/06, Terry C. Mergl <[EMAIL PROTECTED]> wrote:
>
>> Good morning everyone.
>> As a novice with CF and newly introduced to one of our Oracle servers,
>> I'm having to rely on a cf query to find the tables and fields that way.
>> I can successfully run a query and list all of my tables, but when I
>> go one step further to list the fields, it is either timing out or
>> stopping about a quarter of the way through and I'm not sure what to do or
>>
> go from here.
>
>> Any advice greatly appreciated.
>> Terry
>>
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> 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.
>
>> --
>> No virus found in this outgoing message.
>> Checked by AVG Free Edition.
>> Version: 7.1.394 / Virus Database: 268.10.5/403 - Release Date:
>> 7/28/2006
>>
>>
>>
>>
>>
>>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:248225
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
