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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
