>         $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!

> On 7 Lip, 20:06, bmills <br...@millz.net> wrote:

> > I'm having some issue using prepared statements in Doctrine_RawSql.
> > Using a query like this:

> >         $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!

> An an aside, is there anyway to use the '->orderBy(CASE WHEN .. )'
> statement in DQL without getting an Unkown Aggregate exception?

> On Jul 7, 2:52 pm, eXtreme <jacek.jedrzejew...@gmail.com> wrote:

> > Because this process happens internally in PDO :P

> > On 7 Lip, 20:06, bmills <br...@millz.net> wrote:

> > > I'm having some issue using prepared statements in Doctrine_RawSql.
> > > Using a query like this:

> > >         $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!

> Regarding the orderby, I'm not sure.. You have RawSql for such
> operations ;d

> On 7 Lip, 21:28, bmills <br...@millz.net> wrote:

> > So you're saying Doctrine_RawSql() bypasses PDO all together? Would I
> > be better off working with a PDO object directly?

> > An an aside, is there anyway to use the '->orderBy(CASE WHEN .. )'
> > statement in DQL without getting an Unkown Aggregate exception?

> > On Jul 7, 2:52 pm, eXtreme <jacek.jedrzejew...@gmail.com> wrote:

> > > Because this process happens internally in PDO :P

> > > On 7 Lip, 20:06, bmills <br...@millz.net> wrote:

> > > > I'm having some issue using prepared statements in Doctrine_RawSql.
> > > > Using a query like this:

> > > >         $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!