Was your problem happening with SP2? If so, there's a hotfix available for
the duplicate function. You might want to check it out here:
http://www.allaire.com/Handlers/index.cfm?ID=19107&Method=Full
Debbie
> -----Original Message-----
> From: Sandra Clark [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 22, 2001 11:31 AM
> To: CF-Talk
> Subject: RE: CF Server Error
>
>
> 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
