How do I go about updating multiple rows of data in MySql with same values. I have a query which pull multiple rows in a lot and bin. I would like to create a transfer button that changes the rows to a new lot and location. What I have doesn't work on multiple rows.
system.db.runPrepUpdate("UPDATE roughstorage SET LBin = ?, Llot = ? WHERE LBin = ? and Llot = ?", [newLBin, newLlot, LBin, Llot] , "Progress")