not 100% sure what you are trying to do with this last where clause: where fld_item_ID = 'evaluate(#FORM.fld_item_ID# & #Qty#)'
are you trying to concatenate the form.fld_item_id with the qty variable? I think that SQL is trying to update where records match that whole piece of text in single quotes above You could try: where fld_item_ID = #evaluate(FORM.fld_item_ID & Qty)# any use?? On 9/7/06, Web Master <[EMAIL PROTECTED]> wrote: > 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:252338 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
