How to set literal string values in Doctrine Update queries?

Question

For doctrine 1.2, I find plenty of examples like these:

$q = Doctrine_Query::create()
->update('mytable')
->set('amount', 'amount+200')
->whereIn ('id', $ids);

What I want to do however is a different set:

->set('name', 'foo bar')

This however, leads to exception. Of course, because foo is no column, like amount. No luck with '´foo bar´' either. How can I clarify foo bar is a string literal?

I believe this is the right place to look, but I don't find further info. Also: I would love to know more about the 'mixed params' and 'string update' mentioned there. Perhaps there's a DOCTRINE::FLAG_LITERAL or such?

Apparently, here is an answer. But I habe yet to understand, how Doctrine knows, if e.g. "John" is a column or a literal...: http://stackoverflow.com/questions/4803436/update-multiple-columns-with-doctrine-in-symfony — Frank N, Nov 25 '11 at 11:47

score 3 · Accepted Answer · answered Dec 29 '11 at 00:20

3

Use:

->set('name', '?', 'foo bar')

This is the equivalent of doing the following in DQL

SET name = ?

answered Dec 29 '11 at 00:20

dbellizzi

713
8
18

score 0 · Answer 2 · answered Oct 26 '21 at 14:19

0

You can also use :

$q = Doctrine_Query::create()
    ->update('mytable')
    ->set('name', ':name')
    ->setParameter('name', 'foo bar')

answered Oct 26 '21 at 14:19

Yoann Kergall

2,993
5
22
23

How to set literal string values in Doctrine Update queries?

2 Answers2