Order by Syntax

Results 1 to 2 of 2

Thread: Order by Syntax

  1. #1
    Join Date
    Dec 1969

    Default Order by Syntax

    Is there a way that I can order documents by their ID number but in the way that I want them to return?<BR><BR>For example, I have five documents and I want to retun them in the order: 5, 3, 1, 2, 4 - where easch number refers to the ID of the document.<BR><BR>Is this possible?<BR><BR>Damien

  2. #2
    Join Date
    Dec 1969

    Default RE: Order by Syntax

    I do not think that would be possible via the SQL select statement. <BR><BR>Is there a pattern to the numbers? Then you can just grab all and then do a loop through. If not, you may be stuck doing display of results manually, typing it all out. (well, maybe do a function and send it the ID numbers to display, in that order).

Posting Permissions

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