just set the NAME attribute of cfquery tag to "application.whatever" (the
same works for other scopes).
However, if you're going to stick it in the application scope you're going
to have to lock it whenever you reference it...
You might be better off ptting it in the request scope and using query
caching,
eg
<cfquery datasource="#request.dsn#"
name="request.myquery"
cachedwithin="#request.mytimespan#">
SELECT this
FROM that
</cfquery>
Then you'll have to work out how to refresh it, but then you'd have to do
that anyway if you were putting it in the application scope....
Bert
> -----Original Message-----
> From: Trent Shepherd [mailto:[EMAIL PROTECTED]]
> Sent: 18 April 2001 12:54
> To: Fusebox
> Subject: Setting Query as an Application Var
>
>
> Hi Guys and Gals
> I am looking to set the result of a query to an appliaction
> variable. This will be for a menu item.
> Can anybody tell me whether this can be done and/or show me
> sonme examples of code.
>
> Thanks in Advance
>
> Trent Shepherd
> Nemas
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
