we have seen the same thing as well. we never saw it running 4.0. we were
running 4.5 for about 2 months when it showed up suddenly. it was happening
about once a day for 2 weeks. then as suddenly as it appeared, it was gone.
we are still unsure as to why it happened.
tyler
-----Original Message-----
From: Trent Shepherd [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 12:42 PM
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
