access variables from Appliction.cfc

application.cfc, cfquery, coldfusion, coldfusion-10, database

Solution

To answer this specific question, you do NOT need to provide the datasource attribute. Your query should look like this:

<cfquery name='Q'>
    SQL GOES HERE
</cfquery>

THIS.datasource becomes the default datasource (as of CF9).

Problem

I would like to know the new way of calling variables from the Application.cfc file when using the script function, which has the format of "this.something" My example: ``` component { // application variables this.datasource = "my DSN"; } ``` Now in my cfquery I want to access this. I used in the past I would use [cfset REQUEST.dataSource ="MyDSN"] in the Application.cfc, and then in my cfqrey I would say; ``` <cfquery name="rs_dailytip" datasource="#REQUEST.dataSource#"> My SQL </cfquery> ``` My question is how to do this with the new Application.cfc where I am using "this.datasource"?

Original source