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:260517
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Reply via email to