posted 16 years ago
Hi All,
there is one functionality in our project like, selecting set of customers based upon some criteria like date of purchase, dept, so and so...
Let us say in the first page get the dates, second page get the amount it will go upto next 4 pages , we ran the query with all the parametes from all the 6 pages and get the result to the last page. its taking long time to run it, because it really a big query with joins n very large table as well.
Now whar we are planning is when we get the date in the first page run the query and get the result, get the next parameter and run the query against the previous result with the current parameter and proceed furthur upto the last result page.
My question is
How can I store the result after running the query in each page, how to keep maintain for geting another parameter and run it ?
Its kind of confusing I know, but i would like to do it in this way..
Please do help me..
Thanks!!!