If I understand what you are asking, why do you not just set your DSN as an Application variable?
<cfset Application.DataSource = "dev"> or <cfset Application.DataSource = "test"> You would use whichever one you wanted while testing and then just change this one spot in your Application.cfm file when you were ready to go live. Create the ODBC connections and just call the correct one in your code. In your templates then, your queries would be like: <CFQUERY NAME="qMyQuery" DATASOURCE="#Application.DataSource#"> Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] -----Original Message----- From: bajaria aslam [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 3:36 PM To: CF-Talk Subject: Can we have two datasources with the same name? Hi. Suppose I have a datasource datasource1 pointing to Database1 on a SQL Server called test. Can I have another datasource called datasource1 pointing to Database1 on SQL Server called dev? The datasource1 currently works fine on http://localhost/ I have created a virtual site called http://localhost/Dev So, is there a way to have the same datasource name to point to different servers depending on if I am under http://localhost/ or http://localhost/dev? That way, I thought, I don't have to keep changing the cf code when the code moves to Test server from Dev. Please let me know if you need more details. Thanks AB __________________________________________________ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
