Hi Patricia,
No errors, just not sure how to write the syntax to make it work. The
problem I'm having is inputing a quanity in a form that was generated by a
loop, then on the next page updating a table where the Quantity is paired
with Item_Number.So far I can produce what I need in two separate places.
Don't know how to combine the two.
Note - F004 should have Quantity of 1
F065 Quantityof 2
A400 Quantity of 3
ACTION PAGE TOP:
<cfloop index="The_Item_Number" list="#ITEM_NUMBER#" delimiters=",">
#The_Item_Number#<br>
</cfloop>
<cfloop index="TheQuantity" list="#QUANTITY#" delimiters=",">
UPDDATE BOM
SET QUANTITY = '#TheQuantity#'
WHERE DRAWING_NUMBER = '#DRAWING_NUMBER#' AND ITEM_NUMBER = ???
</cfloop>
ACTION PAGE DISPLAY:
F004
F065
A400
UPDDATE BOM SET QUANTITY = '1' WHERE DRAWING_NUMBER = 3000-04
UPDDATE BOM SET QUANTITY = '2' WHERE DRAWING_NUMBER = 3000-04
UPDDATE BOM SET QUANTITY = '3' WHERE DRAWING_NUMBER = 3000-04
----- Original Message -----
From: "Patricia Lee" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, March 05, 2001 5:48 PM
Subject: RE: Loops and Update queries
> 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
