[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