Datasrouce set in Application cfc

[TheScarecrow]

I want to set a dataSource in the Application.cfc and then just refer to it in the other pages on the site. How do I set this up? thanks.

[Dan_Bracuk]

Set an application variable in the onApplicationStart method.

[TheScarecrow]

SO something like this
<cffunction name="onRequestStart" returntype="boolean" output="yes">
<CFSET request.dataSource = "enroll">
<cfreturn true>
</cffunction>

Then how do I use it on the other pages?

[Newsgroup_User]

TheScarecrow wrote:
> SO something like this
> <cffunction name="onRequestStart" returntype="boolean" output="yes">
> <CFSET request.dataSource = "enroll">
> <cfreturn true>
> </cffunction>
>
> Then how do I use it on the other pages?
>

OnRequestStart is invoked at the start of every request. So it would be
invoked at least once per page, thus setting that variable for you.

[Newsgroup_User]

like so:

<cfquery name="myquery" datasource="#request.dataSource#">


you could alternatively set the datasource name in application scope in
onAplicationStart function:

<cfset Application.dsn = "mydsn">

then use it on your pages as <cfquery name="myquery"
datasource="#Application.dsn#">

hth

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/