update with query build

Yii 1.1 General Discussion
1

hi, im having troubles with query builder

im ok with select command but with update i can’t get it how to use it to produce:

"UPDATE users SET money = money-1 WHERE id = 1 LIMIT 1"

how can i make it using query builder?

thanks

2

I have always used the db->createCommand(‘UPDATE users SET money = money-1 WHERE id = 1 LIMIT 1’)->execute(); for that but this issue seems interesting…

Have you tried putting the table name in front?





$command->update('users', array(

    'users.money'=>'users.money - 1',

), 'id=:id', array(':id'=>1));
3

not tried yet but i think it will not work, because it will be passed as string

4

try




$command->update('users', array(

    'users.money'=>new CDbExpression('users.money - 1'),

), 'id=:id', array(':id'=>1));
5

Thanks Gustavo :)

6

thanks, that is what i need ;)

7

I need a update query with joins. Can anyone help for this?