There is an interesting issue with BD that I discovered when I was trying it out.
I found that on Linux with Apache, when using user directories with Apache, BD it does not go up through the directory structure to find the Application.cfm or Application.cfc file, as it should. If there is not one of those files in the same directory as the calling page, it fails to find any App.cfm or App.cfc file, so your Application.dsn variable would not be set. I think you said you were on Mac OS, but maybe you could do a test -- set a simple variable in your Application file and see if it gets set properly. Or make sure your Application file is in the same directory as your calling page. This may or may not be your issue, but it sounds like it could be the problem. -- Josh ----- Original Message ----- From: "Teddy Payne" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Wednesday, November 15, 2006 8:29 AM Subject: Re: BlueDragon Question > Is the file in the same directory as the application.cfc? If not, is there > another application.cfc or .cfm in the sub folder? > > Teddy > > On 11/15/06, Jason T. Slack <[EMAIL PROTECTED]> wrote: >> >> I am still getting Application.dsn not found. >> >> -Jason >> >> On Nov 15, 2006, at 10:17 AM, Rick Root wrote: >> >> > What error are you getting now? >> > >> > Rick >> > >> > Jason T. Slack wrote: >> >> Hi Rick, >> >> >> >> I noticed that. Here is what I have: >> >> >> >> 1: >> >> 2: <!--- Check Locations table first to see if the location id and >> >> password is right---> >> >> 3: <cfquery name="ckCreds" datasource="#Application.dsn#"> >> >> 4: SELECT LocationID, LocationName FROM Locations >> >> 5: WHERE LocationID = <Cfqueryparam cfsqltype="cf_sql_varchar" >> >> >> >> ^ Snippet from underlying CFML source >> >> >> >> and I have the following in application.cfc >> >> >> >> >> >> <cffunction name="onApplicationStart" returnType="boolean" >> >> output="false"> >> >> <!--- When did the application start? ---> >> >> <cfset APPLICATION.appStarted = now()> >> >> >> >> <cfset Application.dsn = "webPOS"> >> >> >> >> <cfreturn true> >> >> </cffunction> >> >> >> >> -Jason >> >> >> >> >> >> On Nov 15, 2006, at 9:54 AM, Rick Root wrote: >> >> >> >> >> >>> Jason T. Slack wrote: >> >>> >> >>>> Yeah that put me further along in the process. >> >>> >> >>> <cfquery name="ckCreds" datasource="Application.dsn#"> >> >>> >> >>> You're missing an opening # sign on the datasource attribute >> >>> >> >>> Should be >> >>> >> >>> <cfquery name="ckCreds" datasource="#Application.dsn#"> >> >>> >> >>> whenever you get a missing end tag and you're absolutely sure >> >>> you're not >> >>> missing an end tag, the likely culprit is an unmatched # >> >>> >> >>> Rick >> >>> >> >>> >> >> >> >> >> >> >> > >> > >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260531 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
