Gerald,
This works great. Now where do I go to print the source file name and
location as that's the reason for all this as I can print the page in
CFAdmin that lists all my datasources.

Terry

-----Original Message-----
From: Gerald Guido [mailto:[email protected]] 
Sent: Monday, January 26, 2009 10:21 AM
To: cf-talk
Subject: Re: Printing out a List of all my servers data sources

Q&D

<cfset conn = createObject("java","coldfusion.server.ServiceFactory")>
    <!--- Create a List to loop over --->
    <cfset dbList =
listSort(structKeyList(conn.DataSourceService.getDatasources()),"textnocase"
)>

<cfoutput>
    <cfloop list="#dbList#" index="dsnName">
        #dsnName# <br />
    </cfloop>
</cfoutput>



On Mon, Jan 26, 2009 at 10:57 AM, Terry Troxel <[email protected]> wrote:

> How do I go about printing out a list of all my CFadmin data sources with
> the location of the source files as well?
>
> I would like it for back up purposes in order to recreate the dsn's if I
> want to move the server.
>
>
>
> Terry Troxel
>
>
>
>
>
>
> 



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318560
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Reply via email to