Fix here on 1/13/2000 2:45PM by Mark for Mysql; simulating the following with two queries (Mysql requires this). INSERT INTO orders (orderdate, approvalcode, receiptnum, tax1, tax2, custpo, custid, repid, comments, shiptype, shipcharge, totalcharge, testtrans, taxcharge, tax3, dateordered, affid, commissionpaid, commissionreported, discount, shipaddress, shipcity, shipprov, shippostal, shipcountry, storeid, notes, shipname, shipcompany) SELECT :todaydate, approvalcode, receiptnum, tax1, tax2, custpo, custid, repid, comments, shiptype, 0, 0, testtrans, 0, tax3, dateordered, affid, commissionpaid, commissionreported, discount, shipaddress, shipcity, shipprov, shippostal, shipcountry, storeid, '[Backorder] Parent order: :id', shipname, shipcompany FROM orders WHERE id=:id AND storeid=:storeid Fix here on 1/13/2000 2:47PM by Mark for Mysql; simulating the following with two queries (Mysql requires this). INSERT INTO orderdetail (pid, ordid, qty, sell, styletypeid, commissionrate, writeintext, storeid, shipped_key, shipped_sn, gen_done) SELECT pid, :bo_ordid, :bo_qty, sell, styletypeid, commissionrate, writeintext, storeid, shipped_key, shipped_sn, gen_done FROM orderdetail WHERE id=:detail_id AND storeid=:storeid