First, sorry for the late reply.
I think this is an "Order by" with COLLATION issue.
My kereset.datum column in my query sorting well if I'm defined the
table withouth COLLATE MAGYAR and modified my query like this:
"SELECT szemely.nev, szemely.anyanev, szemely.szulhely, szemely.adoszam,
kereset.datum,szemely.id FROM szemely,kereset WHERE (kereset.datum >=
19950101 AND kereset.datum <= 19951231) AND (szemely.nev >= '0000000'
AND szemely.nev <= 'zzzzzzz') AND kereset.id = szemely.id ORDER BY
szemely.nev COLLATE MAGYAR,szemely.anyanev COLLATE MAGYAR"
But in this case the "szemely.nev >= '0000000' AND
szemely.nev <= 'zzzzzzz'" doesn't work because - I think - this is
processed in default COLLATION order.
I'm now in trap. :(
Fred Williams írta:
I also have an issue with "Order By" with one of my queries as well. Iam 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]
-----------------------------------------------------------------------------
--
regards
----
kiru
----
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------