Sorting RecordSet II

Results 1 to 2 of 2

Thread: Sorting RecordSet II

  1. #1
    David Mach Guest

    Default Sorting RecordSet II

    Hi there,<BR><BR>I&#039m trying to sort a recordset I have created from complex query (many UNION and _calculated_ fields). This query can&#039t be sorted by ORDER BY.<BR><BR>Thanks!<BR><BR>David

  2. #2
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: Sorting RecordSet II

    I hate those complex queries, because they are difficult to order. Well, you could load all of the columns into an array, then sort the array using QuickSort. I won&#039t lie to you, it will be difficult to setup, and not the quickest thing in the world (since you have to iterate through your entire recordset, then sort it, then display is), but it can be done. The code for QuickSort is available on 4Guys at:<BR><BR>http://www.4guysfromrolla.com/webtech/012799-1.shtml

Posting Permissions

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