Z
ziad.ali
Guest
In PHP and MySQL I can do pagination of data like this:
select * from customers LIMIT $start, $limit;
The result will return me the page I'm requesting. Is it possible to do something like this using Progress 4GL?
But how can I set a limit and pages for that query search?
Example of the pagination:
I have 20.000 customers in my database. In each search I made, I want to separate the result. The limit I want to sent to the application is 100 rows of 1000. And when the user press page 2, it returns another 100 (but not the old 100) rows.
Does that make sense?
UPDATE
I'm using a technology from Adobe called Flex. The language Flex does not connect to the database directly, it depends on a back end language to do that.
So I'm using Flex and Progress 4GL. My flex application has a datagrid (like browser in 4GL) to show the data retrieved from my 4GL database.
The problem is that the database is huge, so I need to paginate the data. Each time the user clicks on another page, the Flex application has to communicate with Progress 4GL to retrieve the other page data. But, each click of the button is a different call so the Progress won't have any knowledge of the previous query.
How can I go from the 1st page to the 7th using a query?
Continue reading...
select * from customers LIMIT $start, $limit;
The result will return me the page I'm requesting. Is it possible to do something like this using Progress 4GL?
- I do not use -> select from customers
- I use -> for each customers
But how can I set a limit and pages for that query search?
Example of the pagination:
I have 20.000 customers in my database. In each search I made, I want to separate the result. The limit I want to sent to the application is 100 rows of 1000. And when the user press page 2, it returns another 100 (but not the old 100) rows.
Does that make sense?
UPDATE
I'm using a technology from Adobe called Flex. The language Flex does not connect to the database directly, it depends on a back end language to do that.
So I'm using Flex and Progress 4GL. My flex application has a datagrid (like browser in 4GL) to show the data retrieved from my 4GL database.
The problem is that the database is huge, so I need to paginate the data. Each time the user clicks on another page, the Flex application has to communicate with Progress 4GL to retrieve the other page data. But, each click of the button is a different call so the Progress won't have any knowledge of the previous query.
How can I go from the 1st page to the 7th using a query?
Continue reading...