Create a template and add it to all of the files needed. All you need it one line.
datasource.cfm <cfset datasource = "changethenameofthedatasourcehere"> Then for your queries: <cfquery name="whatever" datasource="#datasource#"> select * from table </cfquery> So the files would look like this: <cfinclude template="/datasource.cfm"> <cfquery name="whatever" datasource="#datasource#"> select * from table </cfquery> At 01:36 PM 12/13/2001 -0800, you wrote: >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 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
