Issue with prepared statements using Doctrine_RawSql - doctrine-user

Message from discussion Issue with prepared statements using Doctrine_RawSql

bmills

More options 7 July, 20:28

From: bmills <br...@millz.net>

Date: Tue, 7 Jul 2009 12:28:43 -0700 (PDT)

Local: Tues 7 July 2009 20:28

Subject: Re: Issue with prepared statements using Doctrine_RawSql

  Reply to author
  |
  Forward | Print | View thread
  | Show original
  | Report this message | Find messages by this author
  

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!

Reply to author Forward