Hi,
are you doing something like <cfif myVar EQ ""> in your cfexectask.cfm? This
is known to generate PCode errors sometimes. (Could even be that the
CFSCHEDULE has nothing to do with the error at all, although it is mentioned
in the error msg!)
And for the "unknown query" ... maybe the crashing template uses the same
datasource and when it crashes the datasource is locked? Just guessing
though, hard to say without more details...
HTH,
Chris
> > > unknown exception condition
> > > PCodeRuntimeContextImp::setVariableThe error
> > > occurred while processing an element with a general identifier of
> > > (CFSCHEDULE), occupying document position (3:1) to (5:13).Date/Time:
> > > 02/11/01 21:51:28Browser: Remote Address: Template:
> > > C:\CFUSION\Scripts\cfexectask.cfmQuery String: TASK=check for
> > > db upload
> > >
> > > (all of them in cfschedule processing)
> > > ......and right about the same time, this simple piece of code:
> > >
> > > <CFQUERY NAME="Getcarbrands" DATASOURCE="dsn">
> > > SELECT distinct Merk FROM Cars
> > > </CFQUERY>
> > >
> > > <SELECT name="Merk">
> > > <CFOUTPUT QUERY="Getcarbrands">
> > > <OPTION VALUE="#Merk#">#Merk#</OPTION>
> > > </cfoutput>
> > > </SELECT>
> > >
> > > started throwing this exception:
> > >
> > > QUERY The QUERY attribute of the tag does not specify the name of an
> > > available query
> > > The error occurred while processing an element with a general
> > > identifier of
> > > (CFOUTPUT), occupying document position (270:1) to (270:31)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
