ARe you experiencing an error during some part of the process? Is it a sql
problem or a cf / display problem? More detailed information please?
Inluding any error messages if applicable...
|-----Original Message-----
|From: Shannon Carr [mailto:[EMAIL PROTECTED]]
|Sent: Monday, March 05, 2001 4:17 PM
|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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
