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