Re: Error in Insert on Duplicate Key Update

2005-01-14 Thread Richard Whitney
Quoting sam wun <[EMAIL PROTECTED]>: > HI, > > the following insert/update produced error. I m using MySQL 5.0. > $insert_sql = qq {insert into inventory > (prodcode,qty,lastupdatedate,prodname,basename,vendorname,cost) > values (?,?,?,?,?,?,?) ON DUPLICATE KEY > U

Error in Insert on Duplicate Key Update

2005-01-13 Thread sam wun
HI, the following insert/update produced error. I m using MySQL 5.0. $insert_sql = qq {insert into inventory (prodcode,qty,lastupdatedate,prodname,basename,vendorname,cost) values (?,?,?,?,?,?,?) ON DUPLICATE KEY UPDATE qty=$q