Jason can you run the following?: <cfquery name="ckCreds" datasource="webPOS"> SELECT LocationID, LocationName FROM Locations WHERE LocationID = <Cfqueryparam cfsqltype="cf_sql_varchar"> </cfquery
Regards Mark Drew On 15 Nov 2006, at 13:59, Jason T. Slack wrote: > I am evaluating Blue Dragon for OS X since I am invested in CF (new > to it, but making the investment) and CF 7 does not run on Intel macs. > > I moved over an application that works on CF Server to Blue Dragon > install on my Powerbook. > > I setup a DSN called webPOS using the Blue Dragon Administrator > (MySQL 5). I also downloaded and followed the instructions for > Connector/J and Blue Dragon to talk nicely. > > When I try to run a CFQUERY I get: > > application.dsn doesn't exist. > > 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 > > even though in my application.cfc i have the following: > > <cffunction name="onApplicationStart" returnType="boolean" > output="false"> > <!--- When did the application start? ---> > <cfset APPLICATION.appStarted = now()> > > <cfset application.dsn = "webPOS"> > > <cfreturn true> > </cffunction> > > Can you help me work through these issues? > > 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:260538 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4