Sorting records

Results 1 to 2 of 2

Thread: Sorting records

  1. #1
    Join Date
    Dec 1969

    Default Sorting records

    How do i add something that will sort this recordset?<BR><BR>sSearchParams = "JobCatID," & iJobCatID<BR>iPage = doForm("Page", "1")<BR>iRecsPerPage = doForm("RecsPerPage", "50")<BR> <BR>Set oRS = PageIt(GetRecords("sp_Get_Jobs " & iJobCatID), iPage, iRecsPerPage)

  2. #2
    Join Date
    Dec 1969

    Default RE: Sorting records

    Sort? You mean order by?<BR><BR>Well, I haven&#039;t got a clue what "PageIt" or "GetRecords" are, but I assume they execute the stored procedure "sp_Get_Jobs". The BEST place to put the order by is inside the stored procedure.<BR><BR>In fact, bearing in mind that your PageIt() function&#039;s going to start paginating your results, you need to make sure that the recordset is already sorted at this point. So, you&#039;ll probably find that it&#039;s the only way.<BR><BR>Craig.

Posting Permissions

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