[Catalyst] order_by

Will Smith willbelair at yahoo.com
Fri Dec 15 14:26:44 GMT 2006


thanks all for your tip,
 
 Yes, in the DBIx::class pod, there's no  {}, and I have tried that, and it does not work. My purpose is "select * from book order by 'title' ", not just a found set. 
 
 Thank you.
 Will

Sébastien Wagener <sebastien.wagener at gmail.com> wrote: On Thu, 2006-12-14 at 18:51 -0800, Andrew Peebles wrote:
> Will Smith wrote: 
> I think you want:
> 
> $c->stash->{book} = [$c->model('myappDB::Book')->search( {}, {order_by
> => 'title} )];
The DBIx::Class::ResultSet pod recommends using undef instead of {}, if
I remember right.
> 
> That's how I remember doing it ...

> > 
> > _______________________________________________
> > List: Catalyst at lists.rawmode.org
> > Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
> > Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/
> > Dev site: http://dev.catalyst.perl.org/
> >   
> 
> _______________________________________________
> List: Catalyst at lists.rawmode.org
> Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
> Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/
> Dev site: http://dev.catalyst.perl.org/


_______________________________________________
List: Catalyst at lists.rawmode.org
Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/
Dev site: http://dev.catalyst.perl.org/


 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20061215/e3a7aba5/attachment.htm


More information about the Catalyst mailing list