Jason, Did you get this resolved? If not, please post your current code and error messages.
-Aaron On 11/15/06, Teddy Payne <[EMAIL PROTECTED]> wrote: > 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:260530 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
