Re: [sqlite] collation with order by bug? (was: multiple order by value bug? )

2006-12-28 Thread kiru
unc, 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|a

Re: [sqlite] multiple order by value bug?

2006-12-12 Thread kiru
t 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|bb