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]
-