thanks all for your tip,<br> <br> Yes, in the DBIx::class pod, there's no&nbsp; {}, and I have tried that, and it does not work. My purpose is "select * from book order by 'title' ", not just a found set. <br> <br> Thank you.<br> Will<br><br><b><i>Sébastien Wagener &lt;sebastien.wagener@gmail.com&gt;</i></b> wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> On Thu, 2006-12-14 at 18:51 -0800, Andrew Peebles wrote:<br>&gt; Will Smith wrote: <br>&gt; I think you want:<br>&gt; <br>&gt; $c-&gt;stash-&gt;{book} = [$c-&gt;model('myappDB::Book')-&gt;search( {}, {order_by<br>&gt; =&gt; 'title} )];<br>The DBIx::Class::ResultSet pod recommends using undef instead of {}, if<br>I remember right.<br>&gt; <br>&gt; That's how I remember doing it ...<br><br>&gt; &gt; <br>&gt; &gt; _______________________________________________<br>&gt; &gt; List: Catalyst@lists.rawmode.org<br>&gt; &gt; Listinfo:
 http://lists.rawmode.org/mailman/listinfo/catalyst<br>&gt; &gt; Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/<br>&gt; &gt; Dev site: http://dev.catalyst.perl.org/<br>&gt; &gt;   <br>&gt; <br>&gt; _______________________________________________<br>&gt; List: Catalyst@lists.rawmode.org<br>&gt; Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst<br>&gt; Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/<br>&gt; Dev site: http://dev.catalyst.perl.org/<br><br><br>_______________________________________________<br>List: Catalyst@lists.rawmode.org<br>Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst<br>Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/<br>Dev site: http://dev.catalyst.perl.org/<br></blockquote><br><p>&#32;__________________________________________________<br>Do You Yahoo!?<br>Tired of spam?  Yahoo! Mail has the best spam protection around <br>http://mail.yahoo.com