~~~
- Original Message -
From: "Steve Howard" <[EMAIL PROTECTED]>
To: "Abdulaziz Ghuloum" <[EMAIL PROTECTED]>; "Rajeev Rumale"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, June 27, 2001 7:47 AM
Subject: R
ew little ideas,
but the actual answer will vary between DBMS's.
Enjoy,
Steve Howard
-Original Message-
From: Abdulaziz Ghuloum [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001 1:19 PM
To: Rajeev Rumale; [EMAIL PROTECTED]
Subject: Re: Paging the Data..
You can limit the numb
Hello Rajeev,
Tuesday, June 26, 2001, Rajeev Rumale <[EMAIL PROTECTED]> wrote:
RR> I have a SQL query which returns me a very large number of records. since it
RR> is not good to list them all I want to *page* them.( Displaying a fixed
RR> number of records at a time) and the more forward and ba
You can limit the number of records returned by the query by using the SQL
LIMIT modifier
"select * from mytable where status = 1 limit 10;"
Consult *your* database engine for more information.
Aziz,,,
On Tue, 26 Jun 2001 19:41:45 +0800, Rajeev Rumale said:
> Hi,
>
> I have a SQL query wh
You should consider looking at the Curses module.
On 26 Jun 2001 19:41:45 +0800, Rajeev Rumale wrote:
> Hi,
>
> I have a SQL query which returns me a very large number of records. since it
> is not good to list them all I want to *page* them.( Displaying a fixed
> number of records at a time) an
Hi,
I have a SQL query which returns me a very large number of records. since it
is not good to list them all I want to *page* them.( Displaying a fixed
number of records at a time) and the more forward and back ward. Just like
the serch engines display their results.
I would like to know if the
