Re: [sqlite] multiple order by value bug?

2006-12-12 Thread Will Leshner
On 12/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: No, I accomodate only te kereset.datum colum to the ORDER BY clause, and then the result come wrong. Ah. Ok. Sorry for the confusion. - To unsubscribe, send

RE: [sqlite] multiple order by value bug?

2006-12-12 Thread Fred Williams
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 que

Re: [sqlite] multiple order by value bug?

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

Re: [sqlite] multiple order by value bug?

2006-12-12 Thread Will Leshner
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

[sqlite] multiple order by value bug?

2006-12-12 Thread info
Hi list, sqlite version: 3.3.8 I have 2 tables: --- CREATE TABLE kereset (realid INTEGER NOT NULL, id INTEGER NOT NULL, datum DATETIME, jogcim CHAR(1) NOT NULL, brutto INT NOT NULL, ado INT NOT NULL, adoalap INT NOT NULL); CREATE TABLE szemely (id INTEGER NOT NULL, nev VARCHAR(128)