|
|
doctrine-user |
Because this process happens internally in PDO :P
On 7 Lip, 20:06, bmills <br...@millz.net> wrote:
> $q = new Doctrine_RawSql();
> Yields SQL like this:
> SELECT [list of fields]
> Any idea why my parameters aren't substituted into the query? Thanks!
> I'm having some issue using prepared statements in Doctrine_RawSql.
> Using a query like this:
> $result = $q->select('{p.*}')
> ->from('photographers p')
> ->addComponent('p', 'Photographer')
> ->where('p.city_id = ?')
> ->orderBy('CASE WHEN p.lname < ? THEN 1 ELSE 0 END,
> p.lname ASC')
> ->execute(array(35, "foo%"));
> echo $q->getSql();
> FROM photographers p
> WHERE p.city_id = ?
> ORDER BY
> CASE WHEN p.lname < ? THEN 1 ELSE 0 END, p.lname ASC