Hi All,
Please do not reply to my earlier mail that brought up this topic. I
mixed up a few things there, it is all working fine now.
Bart
Bart McLeod schreef:
Hi All,
If I call Zend_Db_Table_Abstract::update() with valid clause and valid
data I get this strange error:
*array(1) { [0]=> string(15) "item_id = '237'" } array(1) { [0]=>
string(15) "item_id = '237'" } SQLSTATE[42000]: Syntax error or access
violation: 1064 You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near '.`1`.`home`.`nl`.`werq`.`*
It seems that in the internal values list, it uses a dot as a
separator instead of a comma. It should be '1', 'home', 'nl', 'werq'
if these are data to be inserted.
OS: Vista
DB: MySQL
The update works if I use Zend_Db::update() instead of zend_db_table....
Bart
