db query returns many records

A

Andrew Poulos

I have a query to a db that returns several thousand records. I can
paginate the records so that the user is presented with only a small
number at one time but I'm having problems with out to go about doing
what I want to do.

There are a number of scenarios:

1. Users page through the records, select the one they want and click OK.

2. Users click enter some search criteria, click Search, are presented
with the results of the search, page through them (if necessary), select
the one they want and click OK.

3. On a different page there's the records returned from the db and a
list of selected records. Users page through the records, select the
ones they want and click Add to add them, one at a time, to the list (at
the same time they are removed from the records).

4. Same as 3 but with search capabilities.

I can build the bits individually but I'm having trouble putting
everything together. For example, in 2 do I hide the originally returned
records and display the search results or should I open a new window
with the search results? And in 3. as an item is added to the list do I
re-paginate the the returned records?

How should I go about approaching this?

Andrew Poulos
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,769
Messages
2,569,579
Members
45,053
Latest member
BrodieSola

Latest Threads

Top