Opps, good catch, Yes this and restarting CF fixed that issue. Thanks again,
-Jason On Nov 11, 2006, at 10:04 AM, Robertson-Ravo, Neil (RX) wrote: > Sorry, damn Blackberry messing up text.... Damn Suretype... > > I meant to say you are not setting application.dsn, but you are > setting > application.datasource. > > A simple <cfdump var="#application#"> will show you your vars. > > > > > > > "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, > Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed > Business, > Registered in England, Number 678540. It contains information > which is > confidential and may also be privileged. It is for the exclusive > use of the > intended recipient(s). If you are not the intended recipient(s) > please note > that any form of distribution, copying or use of this communication > or the > information in it is strictly prohibited and may be unlawful. If > you have > received this communication in error please return it to the sender > or call > our switchboard on +44 (0) 20 89107910. The opinions expressed > within this > communication are not necessarily those expressed by Reed > Exhibitions." > Visit our website at http://www.reedexpo.com > > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > To: CF-Talk > Sent: Sat Nov 11 15:00:03 2006 > Subject: Re: More DSN Troubles > > I can only see you setting application.dsn, you are however setting > application.datasource. > > > > > > > > > "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, > Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed > Business, > Registered in England, Number 678540. It contains information > which is > confidential and may also be privileged. It is for the exclusive > use of the > intended recipient(s). If you are not the intended recipient(s) > please note > that any form of distribution, copying or use of this communication > or the > information in it is strictly prohibited and may be unlawful. If > you have > received this communication in error please return it to the sender > or call > our switchboard on +44 (0) 20 89107910. The opinions expressed > within this > communication are not necessarily those expressed by Reed > Exhibitions." > Visit our website at http://www.reedexpo.com > > -----Original Message----- > From: Jason T. Slack > To: CF-Talk > Sent: Sat Nov 11 14:55:25 2006 > Subject: More DSN Troubles > > I have an application.cfc that looks like: > > <!--- Application.cfm ---> > <cfcomponent output="false"> > > <cfset THIS.name = "webPOS"> > > <cffunction name="onApplicationStart" returnType="boolean" > output="false"> > <!--- When did the application start? ---> > <cfset APPLICATION.appStarted = now()> > > <cfset application.dataSource = "MyDSN"> > > <cfreturn true> > </cffunction> > > <cffunction name="onApplicationEnd" returnType="void" > output="false"> > <cfargument name="appScope" required="true"> > > <!--- Log how many minutes the application stayed alive ---> > <cflog file="#THIS.name#" text="App ended after #dateDiff > ('n',ARGUMENTS.appScope.appStarted,now())# minutes."> > > </cffunction> > > <cffunction name="onRequestStart" returnType="boolean" > output="true"> > <!--- Any variables set here can be used by all our pages ---> > <cfset request.dataSource = "MyDSN"> > <cfset request.companyName = "Computer Outlet"> > > <cfreturn true> > </cffunction> > > <cffunction name="onRequestEnd" returnType="void" output="true"> > > </cffunction> > > </cfcomponent> > > And I can calling: > > <cfquery name="ckCreds" datasource="#application.dsn#"> > SELECT LocationName FROM > WHERE LocationID = <Cfqueryparam cfsqltype="cf_sql_varchar" > value="#form.user#"> > AND LocationPassword = <cfqueryparam > cfsqltype="cf_sql_varchar" > value="#form.password#"> > </cfquery> > > <cfif ckCreds.recordCount EQ 1> > <!--- successful login ---> > <cflocation url="main.cfm" /> > <cfelse> > <!--- login failed ---> > <cflocation url="index.cfm" /> > </cfif> > > > but I get an error that states: > > Element DSN is undefined in APPLICATION. > > I dont see why, can anyone point it out? > > Thanks, > > -Jason > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:260014 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
