Datasource Attribute in Application.cfc
You may know about the "datasource" property in ColdFusion 9. It allows you to create a variable in your Application.cfc file called "datasource" and then skip the "datasource" attribute of your query tags. That's pretty neato. Here's how it works. In the Application.cfc properties...
<cfscript>
this.name = 'mort';
this.sessionmanagement = true;
this.datasource = 'myDsn';
</cfscript>
....
<cffunction name="getAllUsers">
<cfset var 'myQry = ''/>
<cfquery name="myQry">
SELECT username, email
FROM users
</cfquery>
<cfreturn myQry/>
</cffunction>
A Minor Detail
There is one issue that I was made aware of with this approach. Super genius guru Phillip Senn had a head scratching problem where he would set this variable in Application.cfc. Periodically he began getting and error which said:
So if you are using this Application based this.datasource approach and you get some random errors where the variable seems undefined - or seems defined as a blank string - start looking for vars that are not properly scoped within your components. It may just fix you right up.
2 Comments
-
Mark,
I can't take credit for this one.
But thanks for posting "Super genius guru" next to my name! -
Thanks so much, I have noticed the very occasional error like this, but could never find an answer.
It then started happening half way through a bulk email send so I really needed to get it fixed. It uses a cfthread so sounds like this scoping issue is the problem.
Thanks to Mark and Phillip.
Sites to Watch
Aggregators
RSS
