I ran into this once, not only would it give me that error, but it would end
up crashing my CF Server and I would have to reboot.

I finally figured out that it would bomb when I was trying to set Recordsets
in the Session scope to Request scope (or Vice Versa) using <cflock>

I did a work around of saving the query clause itself in the Session scope
and letting it run again.

You might want to check your code out. It took me a long time (and a lot of
server restarts) to narrow it down.

Bad Code Example

        <cfquery name="Request.Recordset" datasource="dsn">
                #PreserveSinglequotes(sqlClause)#
        </cfquery>
        <cflock scope="SESSION" TYPE="EXCLUSIVE">
                <cfset Session.Recordset = duplicate(Request.RecordSet)>        <!--- 
This caused
the bomb --->
        </cflock>


Fixed Code Example.
        <cfset Request.SqlClause = "Select * from table">
        <cflock scope="SESSION" TYPE="EXCLUSIVE">
                <cfset Session.SqlClause =Request.SqlClause>    <!--- This fixed 
problem --->
        </cflock>
        <cfquery name="Recordset" datasource="dsn">
                #PreserveSinglequotes(Request.sqlClause)#
        </cfquery>


-----Original Message-----
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 22, 2001 7:08 AM
To: CF-Talk
Subject: RE: CF Server Error


list the CFX tags (if any) you have installed. they're a common culprit of
CFMLInterpreterImp::executepcode errors.

as far as listing code...you'd have to list everything on your box. a lot of
the time, this error isn't caused by anything blatantly obvious.

-----Original Message-----
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 22, 2001 6:50 AM
To: CF-Talk
Subject: Re: CF Server Error


I dont know exactly which versions will cause problems, but some code would
be helpful. We consistently got this error after installing a new version of
the MDAC's with Access 97 databases and pass through queries...


jon
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, January 22, 2001 9:27 AM
Subject: RE: CF Server Error


> We are currently at MDAC 2.5...
>
>
> -----Original Message-----
> From: Jon Hall [mailto:[EMAIL PROTECTED]]
> Sent: 22 January 2001 14:22
> To: CF-Talk
> Subject: Re: CF Server Error
>
>
> Server puke, did you upgrade your MDAC lately?
>
> jon
> ----- Original Message -----
> From: <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, January 22, 2001 8:54 AM
> Subject: FW: CF Server Error
>
>
> > Anyone ideas on this one?
> >
> > Mike Connolly
> > Web Developer
> > New Media
> > Rocom Group Limited
> > Tel:   01937 84 74 96
> > Web: http://www.rocom.co.uk
> >
> >
> >
> >
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: 22 January 2001 09:16
> > To: CF-Talk
> > Subject: CF Server Error
> >
> >
> > Has anyone ever come across this error with CF Server 4.5..
> >
> > "CFMLInterpreterImp::executepcode"
> >
> > If so, what measures were taken to alleviate it?
> >
> > Regards
> >
> > Mike Connolly
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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

Reply via email to