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_01C01E71.BA5B5678
Content-Type: text/plain;
charset="iso-8859-1"
Hey cf'ers,
I have a form with one hidden field and one text field.
this form is generated by a query/loop. I need to loop a query update with
this form. But the query i have below updates all the entries with the same
value. Can anyone give a hand i'm drawing a blank.
Query update code:
<cfloop list="#attributes.items#" index="items">
<cfloop list="#attributes.qty#" index="qty">
<cfquery name="UpdateCart" datasource="#DSN#">
UPDATE CARTITEMS
SET QTY = '#qty#'
WHERE CFID = '#cookie.cfid#'
AND PARTNUMBER = '#items#'
</cfquery>
</cfloop>
</cfloop>
------_=_NextPart_001_01C01E71.BA5B5678
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></TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Hey cf'ers,</FONT>
</P>
<P><FONT SIZE=3D2>I have a form with one hidden field and one text =
field.</FONT>
<BR><FONT SIZE=3D2>this form is generated by a query/loop. I need to =
loop a query update with this form. But the query i have below updates =
all the entries with the same value. Can anyone give a hand i'm drawing =
a blank.</FONT></P>
<BR>
<P><FONT SIZE=3D2>Query update code:</FONT>
</P>
<P><FONT SIZE=3D2><cfloop list=3D"#attributes.items#" =
index=3D"items"></FONT>
<BR><FONT SIZE=3D2><cfloop list=3D"#attributes.qty#" =
index=3D"qty"></FONT>
</P>
<P><FONT SIZE=3D2><cfquery name=3D"UpdateCart" =
datasource=3D"#DSN#"></FONT>
<BR><FONT SIZE=3D2>UPDATE CARTITEMS</FONT>
<BR><FONT SIZE=3D2>SET QTY =3D '#qty#'</FONT>
<BR><FONT SIZE=3D2>WHERE CFID =3D '#cookie.cfid#'</FONT>
</P>
<P><FONT SIZE=3D2>AND PARTNUMBER =3D '#items#'</FONT>
</P>
<P><FONT SIZE=3D2></cfquery></FONT>
<BR><FONT SIZE=3D2></cfloop></FONT>
<BR><FONT SIZE=3D2> </cfloop></FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C01E71.BA5B5678--
------------------------------------------------------------------------------
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.
