RE: Doing multiple inserts using

Michael Rosario Thu, 12 Oct 2000 13:10:38 -0700
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_01C03489.841B4C10
Content-Type: text/plain;
        charset="iso-8859-1"

Thanks for the input....


I found out that the problem was with my WDDX packet.  In the packet, I had
a 8 records going back to the server;  One of the WDDX tags requires you
to provide a record count of how many records you are sending back... This
record count attribute was 9.   So.. I guess CFLOOP was trying to read
another row from it's record set that didnt' actually exist.  This caused
the p Code error...



-----Original Message-----
From: Ricq Pattay [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 12, 2000 4:01 PM
To: CF-Talk
Subject: Re: Doing multiple inserts using <CFLOOP>


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 &lt;CFLOOP&gt;</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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>&lt;CFWDDX =
> ACTION=3D'wddx2cfml' input=3D#hidContent# =
> output=3D'rsRoleMatrix'&gt;</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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>&lt;cfloop =
> query=3D&quot;rsRoleMatrix&quot;&gt;</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>&lt;!-- =
> Insert each role_security record --&gt;</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT =
> SIZE=3D2>&lt;CFTRANSACTION&gt;</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>&lt;cfquery =
> name=3D&quot;insertRoleSecurity&quot; =
> datasource=3D&quot;cwwebapp_#cookie.cwwebappcompanyid#&quot;&gt;</FONT><=
> /P>
>
> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>insert =
> pm_role_security</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>(</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<FONT SIZE=3D2> =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Owner_ID,</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT =
> SIZE=3D2>PM_Role_RecID,</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT =
> SIZE=3D2>PM_Label,</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT =
> SIZE=3D2>PM_Function,</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT =
> SIZE=3D2>PM_Add_Level,</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT =
> SIZE=3D2>PM_Edit_Level,</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT =
> SIZE=3D2>PM_Delete_Level,</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT =
> SIZE=3D2>PM_Inquire_Level,</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT =
> SIZE=3D2>Last_Update,</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT =
> SIZE=3D2>Updated_By</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT =
> SIZE=3D2>)values(</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<FONT SIZE=3D2> =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; #session.userVars[6]#,</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT =
> SIZE=3D2>#intPMRoleRecID#,</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT =
> SIZE=3D2>'#label#',</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT =
> SIZE=3D2>'#function#',</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT =
> SIZE=3D2>#Add_Level#,</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT =
> SIZE=3D2>#Edit_Level#,</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
> ;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT =
> SIZE=3D2>#Delete_Level#,</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT =
> SIZE=3D2>#Inquire_Level#,</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT =
> SIZE=3D2>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; #recLastUpdate#,</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT =
> SIZE=3D2>'#session.userVars[1]#' =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>)</FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT =
> SIZE=3D2>&lt;/cfquery&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT =
> SIZE=3D2>&lt;/cftransaction&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
> ; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT>
> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT =
> SIZE=3D2>&lt;/cfloop&gt;</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 &lt;CFLOOP&gt; 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.

------_=_NextPart_001_01C03489.841B4C10
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>RE: Doing multiple inserts using &lt;CFLOOP&gt;</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>Thanks for the input....</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>I found out that the problem was with my WDDX =
packet.&nbsp; In the packet, I had a 8 records going back to the =
server;&nbsp; One of the WDDX tags requires you</FONT></P>

<P><FONT SIZE=3D2>to provide a record count of how many records you are =
sending back... This record count attribute was 9.&nbsp;&nbsp; So.. I =
guess CFLOOP was trying to read another row from it's record set that =
didnt' actually exist.&nbsp; This caused the p Code error...</FONT></P>
<BR>
<BR>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Ricq Pattay [<A =
HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</FON=
T>
<BR><FONT SIZE=3D2>Sent: Thursday, October 12, 2000 4:01 PM</FONT>
<BR><FONT SIZE=3D2>To: CF-Talk</FONT>
<BR><FONT SIZE=3D2>Subject: Re: Doing multiple inserts using =
&lt;CFLOOP&gt;</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Try moving your &lt;cftransaction&gt; outside of your =
loop. That's what fixed it</FONT>
<BR><FONT SIZE=3D2>for me, although I was using Oracle.</FONT>
</P>

<P><FONT SIZE=3D2>~~~~~~~~~~~~~~~~~~~~~~~~</FONT>
<BR><FONT SIZE=3D2>Ricq Pattay &lt;[EMAIL PROTECTED]&gt;</FONT>
<BR><FONT SIZE=3D2>Univ of Minnesota - Twin Cities</FONT>
<BR><FONT SIZE=3D2>College of Veterinary Medicine</FONT>
</P>
<BR>
<BR>

<P><FONT SIZE=3D2>----- Original Message -----</FONT>
<BR><FONT SIZE=3D2>From: Michael Rosario =
&lt;[EMAIL PROTECTED]&gt;</FONT>
<BR><FONT SIZE=3D2>To: CF-Talk &lt;[EMAIL PROTECTED]&gt;</FONT>
<BR><FONT SIZE=3D2>Sent: Thursday, October 12, 2000 2:34 PM</FONT>
<BR><FONT SIZE=3D2>Subject: Doing multiple inserts using =
&lt;CFLOOP&gt;</FONT>
</P>
<BR>

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

<P><FONT =
SIZE=3D2>---------------------------------------------------------------=
---------------</FONT>
<BR><FONT SIZE=3D2>Archives: <A =
HREF=3D"http://www.mail-archive.com/[email protected]/" =
TARGET=3D"_blank">http://www.mail-archive.com/[email protected]/=
</A></FONT>
<BR><FONT SIZE=3D2>To Unsubscribe visit <A =
HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli=
sts/cf_talk" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
&body=3Dlists/cf_talk</A> or send a message to =
[EMAIL PROTECTED] with 'unsubscribe' in the =
body.</FONT></P>

</BODY>
</HTML>
------_=_NextPart_001_01C03489.841B4C10--
------------------------------------------------------------------------------
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.
RE: Doing multiple inserts using

Reply via email to
