[thelist] mysql - null - returns results anyway
Eduardo Kienetz
eduardok at gmail.com
Wed Dec 23 15:57:36 CST 2009
On Wed, Dec 23, 2009 at 1:53 PM, Bob Meetin <bobm at dottedi.biz> wrote:
> By view I mean I have a list of 50 (say up to 200) or so results and I sort
> them by product name or business name or whatever (order by product name
> asc).
> So the real question which remains unanswered is: Is there a different,
> better method (to sort results)?
>
> Maybe I miscommunicated?
I think the idea is that the view should return 'raw' results. Then
when you're calling the view you do:
select field1,field2,field3 from view order by field2
So if you have 2 places calling the same view but they expect
different sorting, you end up having to force a second sort, etc.
--
Eduardo Bacchi Kienetz
More information about the thelist
mailing list