Couldn't you do something like this?  (not exact code)

<cftry>

    <cfquery datasource=#DoesThisExist#>
        select * from table where 1 = 2
    </cfquery>

    <cfcatch type="Database">
        Something broker
    </cfcatch>
</cftry>

Just an idea.

E

----- Original Message ----- 
From: "Stan Winchester" <[EMAIL PROTECTED]>


Is there a way to test to see if a data source exists? I am creating a setup
routine where the user will enter the data source name, and I would like to
check to see if it exists before using it.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

                                Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
                                

Reply via email to