No extra doc comment needed for this, because the documentation already states that Zend_Db only supports ANSI SQL to conform to most RDBMS.
2007/9/11, Ian Warner <[EMAIL PROTECTED]>: > > 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 > >> > > >
