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, auth, gtrans) 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, auth, gtrans FROM orders WHERE id=:id AND storeid=:storeid ALIAS="InStoreOrder"> 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