Try moving your <cftransaction> outside of your loop. That's what fixed it
for me, although I was using Oracle.
~~~~~~~~~~~~~~~~~~~~~~~~
Ricq Pattay <[EMAIL PROTECTED]>
Univ of Minnesota - Twin Cities
College of Veterinary Medicine
----- Original Message -----
From: Michael Rosario <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Thursday, October 12, 2000 2:34 PM
Subject: Doing multiple inserts using <CFLOOP>
> 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.
>
------------------------------------------------------------------------------
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.
