Sorting recordset w/o requerying

Results 1 to 2 of 2

Thread: Sorting recordset w/o requerying

  1. #1
    Join Date
    Dec 1969

    Default Sorting recordset w/o requerying

    Does anyone have a idea of how I can allow users to sort on all the columns of the recordset with out requerying the recordset. My query takes a while.<BR><BR>I would like to open the connection and recordset on one page and then pass the recordset to a new page for display and sorting purposes. Is this possible. <BR><BR>I looked into using a Array and did not like what I saw.<BR><BR>Thanks for any help.

  2. #2
    Join Date
    Dec 1969

    Default RE: Sorting recordset w/o requerying

    Depends on what you need it for...<BR><BR>you might try using a temp table to hold your records, and then selecting from it order accordingly<BR><BR>but an array still could be your best bet <BR><BR>sponge

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts