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
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
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"
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
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)
5 matches
Mail list logo