>         $q = new Doctrine_RawSql();
>         $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%"));

> Yields SQL like this:
> echo $q->getSql();

> SELECT [list of fields]
> FROM photographers p
> WHERE p.city_id = ?
> ORDER BY
>    CASE WHEN p.lname < ? THEN 1 ELSE 0 END, p.lname ASC

> Any idea why my parameters aren't substituted into the query? Thanks!