Sorting a Recordset

Results 1 to 2 of 2

Thread: Sorting a Recordset

  1. #1
    Join Date
    Dec 1969

    Default Sorting a Recordset

    I am having trouble using the Sort property of a recordset. I have tried to set the cursortype to static, but I receive a message that:<BR>"The operation requested by the application is not supported by the provider. "<BR><BR>Here is some code:<BR>Set rs = Server.CreateObject("ADODB.Recordset")<BR>rs.Curso rType = adOpenStatic<BR>rs.Open query, conn<BR>rs.sort = "Field1 ASC"<BR><BR>Anyone have any suggestions? Thx in advance.

  2. #2
    Join Date
    Dec 1969

    Default RE: Sorting a Recordset

    just add Order By Field1 Asc to your query

Posting Permissions

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