Re: Call for an API standard for SQL statements
From: Mikito Harakiri <mikharakiri_at_iahu.com>
Date: Mon, 25 Oct 2004 09:50:06 -0700
Message-ID: <onafd.38$6e.69_at_news.oracle.com>
Date: Mon, 25 Oct 2004 09:50:06 -0700
Message-ID: <onafd.38$6e.69_at_news.oracle.com>
"Fredrik Bertilsson" <fredrik_bertilsson_at_passagen.se> wrote in message
news:31f7e57d.0410232150.72331ee1_at_posting.google.com...
> That is not what i meant. The programmer only needs to give the
> original query, like "select * from employee order by employee_id".
> The framework will add the extra where condition "emplyee_id > ?" for
> paging. Paging where the sort criteria is built up from multiple
> columns, will give you very ugly and difficult SQL statements. But a
> framework can build them automatically.
Suppose you have list of employees like this
emplyee_id name
---------- -----------
0000000001 John Doe
0000000010 ... 0000000100 ... 0000001000 ... 0000010000 ... 0000100000 ...
How would your paging work? Received on Mon Oct 25 2004 - 18:50:06 CEST