Ah, ok because you're delegating to the criteria object.
Will try that. Thanks.
David
On Jun 11, 10:04 am, "Francois Zaninotto" <[EMAIL PROTECTED]
project.com> wrote:
> Did you try to call the 'addDescendingOrderByColumn()' method directly on
> the sfPropelFinder object? I think it should work, removing the need for
> your patch...
>
> cheers,
>
> François
>
> 2008/6/9 heathd <[EMAIL PROTECTED]>:
>
>
>
> > Hi,
>
> > not sure if this is the correct place to discuss plugins. I just
> > started using sfPropelFinderPlugin, which is very useful, thanks
> > Francois.
>
> > One feature which I needed was the ability to order by complex
> > expressions, rather than just column names. This ability is permitted
> > by using a round bracket in the column name (see
> > BasePeer::createSelectSql()). For example:
>
> > $c = new Criteria();
> > $c->addDescendingOrderByColumn('(IF person.id < 100, 1, 0)');
>
> > of course this example is not a real one, just a simplification to
> > help explain.
>
> > However, this didn't work with the finder, so I made a patch to allow
> > it, which is included at the end of this message.
>
> > What do you think? Would it be possible to incorporate this into the
> > plugin?
>
> > Thanks
>
> > David
>
> > Index: sfPropelFinder.php
> > ===================================================================
> > --- sfPropelFinder.php (revision 9503)
> > +++ sfPropelFinder.php (working copy)
> > @@ -482,7 +482,16 @@
> > */
> > public function orderBy($columnName, $arguments = array())
> > {
> > - $column = $this->getColName($columnName);
> > + // If the column name contains an open bracket, we assume that it
> > + // contains a complex expression rather than a column name. See
> > + // BasePeer::createSelectSql() for the origin of this hack.
> > + if (strpos($columnName, '(') !== false) {
> > + $column = $columnName;
> > + }
> > + else {
> > + $column = $this->getColName($columnName);
> > + }
> > +
> > if(!is_array($arguments))
> > {
> > $arguments = func_get_args();
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/symfony-devs?hl=en
-~----------~----~----~----~------~----~------~--~---
