Bill
Again great answer thank you very much
Maybe a note in the docs then to state that REPLACE wont be supported
and either use the below or create your own query,.
Cheers
Ian
Bill Karwin wrote:
REPLACE is a MySQL-proprietary extension to SQL. It is not supported in
Zend_Db.
In any case, I recommend strongly against using REPLACE. It is really
problematic when using foreign key constraints, for example.
A better choice is INSERT... ON DUPLICATE KEY UPDATE which correctly
performs the insert/update as an atomic action.
http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html
But this also has no direct support in Zend_Db_Table, so you'll have to
do the query yourself.
Regards,
Bill Karwin
-----Original Message-----
From: Ian Warner [mailto:[EMAIL PROTECTED]
Sent: Sunday, September 09, 2007 1:31 AM
To: Zend Framework
Subject: [fw-general] DB Table -Replace
Hi
I cant see any documentation on how to acheive a REPLACE
command within DB TABLE
is this possible and if so what is the best practice
Ian
