CF Dude, I should have thought of that; for some reason my thinking was down another path.
Thanks, Stan >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