SQL Sort?

Results 1 to 2 of 2

Thread: SQL Sort?

  1. #1
    pnub Guest

    Default SQL Sort?

    Ok, I am having trouble opening a database and sorting it by a particular (known) column before outputting the data...here is what I have which opens the database (Access &#039 97):<BR><BR>&#060;%<BR> Dim DB_CONNECTSTRING<BR> DB_CONNECTIONSTRING = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath(strDataBase) & ";"<BR> Set objRecordset = Server.CreateObject("ADODB.Recordset")<BR> objRecordset.Open strBook, DB_CONNECTIONSTRING, adOpenStatic, adLockPessimistic, adCmdTable<BR>%&#062;<BR><BR>What do I need to change/modify or add to have the database sorted by the column named "font_name" (w/out quotes) and in descending alphabetical order (A at the top, Z at the bottom)?

  2. #2
    Imar Spaanjaars Guest

    Default RE: SQL Sort?

    You&#039ll have to add "ORDER BY FONT_NAME" to your strBook string.<BR>That&#039ll do the trick<BR><BR>Imar<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