I am tiring to update multiple records with different values. I am getting the
following error
Error Executing Database Query.
Syntax error (missing operator) in query expression 'fld_item_ID =
'evaluate(1235,1237,1236,1236 & 1)' update tbl_865_orders_items set
fld_qty_shipped = 'evaluate(500,50,100,100 & 2)' where fld_item_ID =
'evaluate(1235,1237,1236,1236 & 2)' update tbl_865_orders_items set
fld_qty_shipped'.
Here is my code
Form
<cfquery name="RequestItemsDetail" datasource="print_shop">
SELECT tbl_masterlist.fld_desc, tbl_865_orders_items.fld_qty_ordered,
tbl_865_orders_items.fld_prod_code , tbl_865_orders_items.fld_item_ID ,
tbl_865_orders_items.fld_qty_shipped
FROM tbl_masterlist, tbl_865_orders_items
WHERE tbl_865_orders_items.fld_wo_num = #fld_wo_num# and
tbl_masterlist.fld_prod_code = tbl_865_orders_items.fld_prod_code
</cfquery>
<cfinput type="hidden" name="records" value="#RequestItemsDetail.recordcount#">
<cfoutput query="RequestItemsDetail">
<cfinput type="hidden" name="fld_item_ID" value="#fld_item_ID#" />
<cfinput type="text" name="fld_qty_shipped"
value="#(fld_qty_ordered-fld_qty_shipped)#" />
</cfoutput>
Update
<cfquery name="setQtystatus" datasource="print_shop">
<cfloop from="1" to="#FORM.records#" index="Qty">
update tbl_865_orders_items
set fld_qty_shipped = 'evaluate(#FORM.fld_qty_shipped# & #Qty#)'
where fld_item_ID = 'evaluate(#FORM.fld_item_ID# & #Qty#)'
</cfloop>
</cfquery>
Can anyone help?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252336
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
