Kinky ColdFusion Calendar System Now Has An Application File
Posted September 4, 2007 at 8:30 AM
A few people have asked me where my DSN information is being set in my Kink ColdFusion Calendar system. This is a totally valid question seeing as it is not set anywhere in my code. Right now, my entire testing sandbox lives under a single Application. Due to that, and the fact that I was trying to make my free ColdFusion calendar system as simple as possible, I wasn't doing any additional work to set the DSN - I was just inheriting the DSN information from the sandbox.
To make the system more clear, I have now added a new build that has a ColdFusion Application.cfc file. This file is a very simple file and defines the Application settings, the page request settings, and a single event method - OnRequestStart() - which defines the REQUEST.DSN structure. In general, this is NOT "best" practice. You shouldn't be setting your DSN information for every page request; instead, you should cache the DSN object in your APPLICATION scope or something to that effect. Again, I was just trying to keep my sub-application as simple as possible.
Hope this clears up some of the confusion.
Click here to view an online demo of the Kinky ColdFusion Calendar System.
Comments (4) | Post Comment | Ask Ben | Permalink | Other Searches | Print Page
Reader Comments
Ben,
One thing I've always wondered about the whole REQUEST.Dsn thing is why choose the REQUEST scope over APPLICATION?
When I first started developing about 2 years back everyone seemed to opt for the APPLICATION.Dsn option, but gradualy over time I've seen people move over to the REQUEST scope for storing this information, is there any particular reason? or just a developer preference?
Thanks mate,
Rob
Posted by Rob Rawlins on Sep 6, 2007 at 1:12 PM
@Rob,
Excellent question. It has more to do with the way my test environment is set up. All of my testing lives under one environment, so I didn't want to make anything tied to the application - my test environment has literally thousands of files in it :) It really makes no difference in my testing, but I just didn't want to store anything in the APP in the testing.
In hindsight, I should have stored it in the APPLICATION scope. It would be a better choice.
Posted by Ben Nadel on Sep 6, 2007 at 1:16 PM
hello Ben,
Thanks tons for the app. I got a great leg up on my project and you showed me things I hadn't thought of yet. Appreciate your site and your work.
Matt
Posted by Matt Bogdanovich on Jul 25, 2008 at 4:17 PM
@Matt,
Always glad to help :)
Posted by Ben Nadel on Jul 25, 2008 at 4:23 PM
