Of course, it's a good idea to stick it in request scope in case you need the DSN for any custom tags, etc.
--- Billy Cravens ----- Original Message ----- From: "Shawn Grover" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, December 14, 2001 11:15 AM Subject: RE: Can we have two datasources with the same name? > I agree. I don't see any reason why a DSN needs to be in the Application, > or Server scope. > I normally just set this as a normal variable in the Application.cfm file. > > ie. > <cfset MyDSN = "DSN Name"> > or > <cfscript> > // declare Application Level Constants > App = structnew(); > StructInsert(App, "DSN", "CAA_EPMS2"); > </cfscript> > > then call it like so: > > <cfquery name="MyQuery" datasource="#MyDSN#"> > or > <cfquery name="MyQuery" datasource="#App.DSN#"> > > Then, for an application wide setting, I simply need to change the value in > Application.cfm. > > If you were on different servers, you could use the same DSN name, but > unfortunately you are not. So you will need two distinct DSNs. (assuming > the development site, and the production site are running simultaneously, on > the same box). > > HTH > > Shawn Grover > > > -----Original Message----- > From: BILLY CRAVENS [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 14, 2001 9:42 AM > To: CF-Talk > Subject: Re: Can we have two datasources with the same name? > > > I used to make that same mistake. However, if you use #application.dsn#, > that means that you have to lock every query - this really hurts > performance. Use a non-shared scope (like request) > > --- > Billy Cravens > > ----- Original Message ----- > From: "Larry Juncker" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, December 13, 2001 3:46 PM > Subject: RE: Can we have two datasources with the same name? > > > > 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists