I have never tried to update multiple records before, if there is a better way I can rewrite the pages.
this is the error I got with your suggestion. Invalid CFML construct found on line 1 at column 5. ColdFusion was looking at the following text: , The error occurred in E:\intranet_development\formsDynamic\print_shop\printJobRequestStatusUpdate.cfm: line 23 Called from E:\intranet_development\formsDynamic\print_shop\printJobRequestStatusUpdate.cfm: line 11 Called from E:\intranet_development\formsDynamic\print_shop\printJobRequestStatusUpdate.cfm: line 1 Called from E:\intranet_development\index.cfm: line 17 21 : update tbl_865_orders_items 22 : set fld_qty_shipped = 'evaluate(#FORM.fld_qty_shipped# & #Qty#)' 23 : where fld_item_ID = #evaluate(FORM.fld_item_ID & Qty)# 24 : </cfloop> 25 : </cfquery> Thank You, Keith ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:252342 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
