Unless I'm missing something here, John, your application.cfm file can be anywhere in the hierarchy of your folder structure...from the same folder as your .cfm file, all the way up to your site's root folder.
CF will look in the folders up the hierarchy until it finds an application.cfm file. I usually just use one application.cfm in the root folder of my sites. I use #application.dsn# as opposed to #request.dsn#. Not having used the Request scope to set my dsn, I don't know what difference, if any, that would make in defining your dsn, but your application.cfm should be able to go anywhere in your sites folder structure that is in or above the folder that contains your .cfm file. Somebody correct me if any of this is wrong... Rick > -----Original Message----- > From: Adrian Lynch [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 23, 2008 4:31 AM > To: CF-Newbie > Subject: RE: cf query help > > Here's another tip. If you want to add a date stamp to a newly inserted row, > you can set the default in the DB to GETDATE() (for SQL Server) and not have > to worry about inserting it. > > CF gets funner all the time! :OD > > Adrian > www.adrianlynch.co.uk > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3861 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
