Do the query using a non-scoped name.
Then do <cfset application.myquery = myquery >
<cfquery datasource="#request.dsn#" name="myquery">
SELECT this
FROM that (into the black)
</cfquery>
<cfset application.myquery = myquery>
---
Jeffrey B. Marsh
Professionals built the Titanic.
Amateurs built the Ark.
-----Original Message-----
From: Trent Shepherd [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 11:42 AM
To: Fusebox
Subject: RE: Setting Query as an Application Var
Ok this is what I thought, However I get the folowing error up to 10 tims
per day.
The query name is "application.menulayout" and the error msg talk about
query names not able to be scoped in this way eg
"MyProject.MyQuery "
Any thoughts
Trent Shepherd
Nemas
<cferror>
Cannot process query Cannot register the query named application.menulayout
with ColdFusion. There are two likely causes of this
problem: � You are using a CFQUERY tag with a scoped query name. Query
names cannot be scoped. For example, MyProject.MyQuery is an
invalid query name. � The query was set as the default query for a tag
like CFOUTPUT, CFLOOP, CFMAIL, etc. However, in the body of
the tag this query was modified or removed. Default queries cannot be
modified or removed inside the bodies of the tags that use
them.
</cferror>
-----Original Message-----
From: Bert Dawson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 18 April 2001 10:07 PM
To: Fusebox
Subject: RE: Setting Query as an Application Var
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
