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:248223
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
