I also have an issue with "Order By" with one of my queries as well. I am doing a multi field Order By and the second of the two fields does not sort in the correct order. I do not have the code in front of me, so can't supply any details.
I have been killing bigger alligators on that project so the Order By issue is on the "to do" list. I just figured it was my Select statement, although it is pretty straight forward, as I remember. Perhaps there is a bug report in the making. Fred > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 12, 2006 2:41 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] multiple order by value bug? > > > Will Leshner írta: > > > On 12/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > >> This query works fine (I think my collate function too), but if I > >> accomodate > >> it with "ORDER BY szemely.nev,szemely.anyanev,kereset.datum", then > >> sorting > >> is in wrong order. > > > > Do you mean you have two "ORDER BY" clauses? Seems like > that would be > > a syntax error, or, at best, undefined. > > No, I accomodate only te kereset.datum colum to the ORDER BY > clause, and > then the result come wrong. > > The two columns (szemely.nev,szemely.anyanev) collated by my > func, and the > third column that I accomodate is collated by the default > sqlite func. > > I want to sort by szemely.nev and when szemely nev is equal, sort by > szemely.anyanev. Then I would like to sort the result by > kereset.datum. > > nev|anyanev|datum > 1. aaa|bbb|111 > 2. aaa|bbb|112 > 3. aaa|bbc|111 > 4. aaa|bbc|112 > > > regards > --- > kiru > ---- > > -------------------------------------------------------------- > --------------- > To unsubscribe, send email to [EMAIL PROTECTED] > -------------------------------------------------------------- > --------------- > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------