When you say there is no unique id do you mean that the fields shown also do
not uniquely identify the record. If so then you can't do it. However if the
item number and whatever criteris you use to select the query in the first
palce are unique then you can.
Generate the name of the quantity field dynamically, as below.
<cfset acount=1>
<cfloop query="itemsbydrawing">
<tr bgcolor="#IIf(CurrentRow Mod 2, DE('ffffff'), DE('#tr_color2#'))#">
<td nowrap> #item_number#</td>
<td nowrap> #Item_description#</td>
<td nowrap align="center">
<input type="Text" name="Quantity" value="#Quantity##acount#" size="4"
maxlength="6"
onFocus="window.status='Quantity'; return true"></td>
<td width="100%"> #CurrentRow#</td>
<!--- <td align="center" nowrap>
<cfinput type="CheckBox" name="DeleteItem" value="yes"></td> --->
</tr>
<input type="hidden" name="ITEM_NUMBER" value="#ITEM_NUMBER#">
<input type="hidden" name="ITEM_DESCRIPTION"
value="#ITEM_DESCRIPTION#">
<cfset acount=acount+1>
</cfloop>
Then on action page loop through the query in the same order:
<cfset acount=1>
<cfloop query="itemsbydrawing">
update table
set quantity=evaluate("form.Quantity#acount#")
where item_number=#itemsbydrawing.item_number#
<cfset acount=acount+1>
</cfloop>
-----Original Message-----
From: Shannon Carr [mailto:[EMAIL PROTECTED]]
Sent: 05 March 2001 21:17
To: CF-Talk
Subject: Loops and Update queries
I am trying to update a table using values that were input on a form using
<cfloop> .
On the input form I am using a loop query to output the Item_Number,
Item_Description and Quantity fields. The user can update the quantity.
On the second page I would like to display inside a table, the variables for
confirmation, then update the table once confirmed. I am having a problem
parsing the Item_Number and Quantity fields together on the display and
table update. The table being updated does not have a unique ID.
INPUT PAGE:
<cfloop query="itemsbydrawing">
<tr bgcolor="#IIf(CurrentRow Mod 2, DE('ffffff'), DE('#tr_color2#'))#">
<td nowrap> #item_number#</td>
<td nowrap> #Item_description#</td>
<td nowrap align="center">
<input type="Text" name="Quantity" value="#Quantity#" size="4"
maxlength="6"
onFocus="window.status='Quantity'; return true"></td>
<td width="100%"> #CurrentRow#</td>
<!--- <td align="center" nowrap>
<cfinput type="CheckBox" name="DeleteItem" value="yes"></td> --->
</tr>
<input type="hidden" name="ITEM_NUMBER" value="#ITEM_NUMBER#">
<input type="hidden" name="ITEM_DESCRIPTION"
value="#ITEM_DESCRIPTION#">
</cfloop>
Any help would be appreciated.
Thanks,
Shannon
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
