> can I add a connection in my Application.cfm template > for my db connection? > what I am doing is creating the db on my local machine > using access 2002 which I don't use a username or password. > When I go live I will upsize it to ms sql 2000 on the > live server which of course will need a username and > password. So I was thinking that I could make the > connection in the application.cfm template then only > have to make the db change there when I go live. Is > that correct? If so what would be the correct way to > do it? I was thinking that I'd just have to do a > <cfset database="#mydb#"> then when I go live add the > username and password but my heads up my bumm at the > moment so I don't know
All you have to do is create a new datasource in the CF Administrator, then use that datasource in your application. To make this as easy as possible, you might create a variable in your Application.cfm file containing the datasource name: <cfset dsn = "MyAccessDB"> Then, within all your CFQUERY tags, you could just do this: <cfquery name="qDoSomething" datasource="#Variables.dsn#"> When you switch to SQL Server, you'd just change your variable in Application.cfm to the new datasource. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
