This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C03483.72D4A0B0
Content-Type: text/plain;
charset="iso-8859-1"
Hello there...
I was wondering if anyone else out there has encountered this situation:
I'm getting a :
CFMLInterpreterImp::executePCode - unknown exception condition
In a coldFusion template used for database I/O to MS SQL server, I receive a
WDDX packet from a client..
I use the following line to parse my packet...
<CFWDDX ACTION='wddx2cfml' input=#hidContent# output='rsRoleMatrix'>
After parsing the packet... I loop over the record set it returns using the
following code:
<cfloop query="rsRoleMatrix">
<!-- Insert each role_security
record -->
<CFTRANSACTION>
<cfquery name="insertRoleSecurity"
datasource="cwwebapp_#cookie.cwwebappcompanyid#">
insert pm_role_security
(
Owner_ID,
PM_Role_RecID,
PM_Label,
PM_Function,
PM_Add_Level,
PM_Edit_Level,
PM_Delete_Level,
PM_Inquire_Level,
Last_Update,
Updated_By
)values(
#session.userVars[6]#,
#intPMRoleRecID#,
'#label#',
'#function#',
#Add_Level#,
#Edit_Level#,
#Delete_Level#,
#Inquire_Level#,
#recLastUpdate#,
'#session.userVars[1]#'
)
</cfquery>
</cftransaction>
</cfloop>
All of the i/o operations complete successfully,but it looks like when it
comes out of the <CFLOOP> the PCode error occurs and execution halts...
Any help would be most appreciated...
Thanks...
------_=_NextPart_001_01C03483.72D4A0B0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>Doing multiple inserts using <CFLOOP></TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Hello there...</FONT>
</P>
<P><FONT SIZE=3D2>I was wondering if anyone else out there has =
encountered this situation:</FONT>
</P>
<P><FONT SIZE=3D2>I'm getting a :</FONT>
</P>
<P> <FONT =
SIZE=3D2>CFMLInterpreterImp::executePCode - unknown exception =
condition</FONT>
</P>
<P><FONT SIZE=3D2>In a coldFusion template used for database I/O to MS =
SQL server, I receive a WDDX packet from a client..</FONT>
</P>
<P><FONT SIZE=3D2>I use the following line to parse my packet...</FONT>
</P>
<P> <FONT SIZE=3D2><CFWDDX =
ACTION=3D'wddx2cfml' input=3D#hidContent# =
output=3D'rsRoleMatrix'></FONT>
</P>
<BR>
<P><FONT SIZE=3D2>After parsing the packet... I loop over the record =
set it returns using the following code:</FONT>
</P>
<BR>
<P> =
=
<FONT SIZE=3D2><cfloop =
query=3D"rsRoleMatrix"></FONT>
<BR> =
=
=
=
<FONT SIZE=3D2><!-- =
Insert each role_security record --></FONT>
<BR> =
=
=
=
<FONT =
SIZE=3D2><CFTRANSACTION></FONT>
<BR> =
=
=
=
<FONT SIZE=3D2><cfquery =
name=3D"insertRoleSecurity" =
datasource=3D"cwwebapp_#cookie.cwwebappcompanyid#"></FONT><=
/P>
<P> =
=
=
=
<FONT SIZE=3D2>insert =
pm_role_security</FONT>
<BR> =
=
=
=
<FONT SIZE=3D2>(</FONT>
<BR> =
=
=
=
<FONT SIZE=3D2> =
Owner_ID,</FONT>
<BR> =
=
=
=
=
<FONT =
SIZE=3D2>PM_Role_RecID,</FONT>
<BR> =
=
=
=
=
<FONT =
SIZE=3D2>PM_Label,</FONT>
<BR> =
=
=
=
=
<FONT =
SIZE=3D2>PM_Function,</FONT>
<BR> =
=
=
=
=
<FONT =
SIZE=3D2>PM_Add_Level,</FONT>
<BR> =
=
=
=
=
<FONT =
SIZE=3D2>PM_Edit_Level,</FONT>
<BR> =
=
=
=
=
<FONT =
SIZE=3D2>PM_Delete_Level,</FONT>
<BR> =
=
=
=
=
<FONT =
SIZE=3D2>PM_Inquire_Level,</FONT>
<BR> =
=
=
=
=
<FONT =
SIZE=3D2>Last_Update,</FONT>
<BR> =
=
=
=
=
<FONT =
SIZE=3D2>Updated_By</FONT>
<BR> =
=
=
=
<FONT =
SIZE=3D2>)values(</FONT>
<BR> =
=
=
=
<FONT SIZE=3D2> =
#session.userVars[6]#,</FONT>
<BR> =
=
=
=
=
<FONT =
SIZE=3D2>#intPMRoleRecID#,</FONT>
<BR> =
=
=
=
=
<FONT =
SIZE=3D2>'#label#',</FONT>
<BR> =
=
=
=
=
<FONT =
SIZE=3D2>'#function#',</FONT>
<BR> =
=
=
=
=
<FONT =
SIZE=3D2>#Add_Level#,</FONT>
<BR> =
=
=
=
=
<FONT =
SIZE=3D2>#Edit_Level#,</FONT>
<BR> =
=
 =
; =
<FONT =
SIZE=3D2>#Delete_Level#,</FONT>
<BR> =
=
=
=
=
<FONT =
SIZE=3D2>#Inquire_Level#,</FONT>
<BR> =
=
=
<FONT =
SIZE=3D2> #recLastUpdate#,</FONT>
<BR> =
=
=
=
=
<FONT =
SIZE=3D2>'#session.userVars[1]#' =
=
=
=
=
</FONT>
<BR> =
=
=
=
<FONT SIZE=3D2>)</FONT>
<BR> =
=
=
=
<FONT =
SIZE=3D2></cfquery> =
</FONT>
<BR> =
=
=
=
<FONT =
SIZE=3D2></cftransaction>  =
; =
</FONT>
<BR> =
=
<FONT =
SIZE=3D2></cfloop></FONT>
</P>
<BR>
<P><FONT SIZE=3D2>All of the i/o operations complete successfully,but =
it looks like when it comes out of the <CFLOOP> the PCode error =
occurs and execution halts...</FONT></P>
<P><FONT SIZE=3D2>Any help would be most appreciated...</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Thanks...</FONT>
</P>
<BR>
<BR>
<BR>
</BODY>
</HTML>
------_=_NextPart_001_01C03483.72D4A0B0--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.