Sorting Query

Results 1 to 2 of 2

Thread: Sorting Query

  1. #1
    Join Date
    Dec 1969

    Default Sorting Query

    I was trying to sort the data with the code I have. How could I rewrite the code so that I can sort the data? Thank you.<BR><BR>&#060;%<BR><BR> Dim objConn<BR> Set objConn = Server.CreateObject("ADODB.Connection")<BR> objConn.ConnectionString = "DSN=vendor"<BR> objConn.Open<BR> <BR> <BR> Dim objRS<BR> Set objRS = Server.CreateObject("ADODB.Recordset")<BR> objRS.Open "PoNewTable", objConn, adOpenForwardOnly, adLockReadOnly, adCmdTable

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default Sort it based on WHAT??

    you can do it easily<BR><BR>objRS.Open "Select * from PoNewTable Order by TheColumnYouWantToSortBy", objConn, adOpenForwardOnly<BR><BR>

Posting Permissions

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