[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