How to access data escending

Results 1 to 3 of 3

Thread: How to access data escending

  1. #1
    Join Date
    Dec 1969
    Posts
    309

    Default How to access data escending

    I have an Asp that access the database and display record one by one but it access the data ascendingly. I want to access descendingly but don&#039t know how.<BR>what parameter do I have to add to make it access the database decendingly.<BR>thanks<BR>Here is my "object" <BR><BR>&#060;OBJECT CLASSID="clsID:BD96C556-65A3-11D0-983A-00C04FC29E33" ID="adcData" HEIGHT=1 WIDTH=1&#062;<BR>&#060;PARAM NAME="Server" VALUE="http://SEVERKAT"&#062;<BR>&#060;PARAM NAME="Connect" VALUE="DSN=adcData"&#062;<BR>&#060;PARAM NAME="SQL" VALUE="SELECT * FROM Escalations"&#062;<BR>&#060;PARAM NAME="SortColumn" VALUE="ID"&#062;<BR>&#060;/OBJECT&#062;

  2. #2
    Join Date
    Dec 1969
    Posts
    52

    Default RE: How to access data escending

    SELECT * FROM Escalations order by ID desc

  3. #3
    Riva Guest

    Default RE: How to access data escending

    This is really a database item, but I&#039ll deign to answer anyway. Use the following SQL keywords, and insert your column name:<BR>"ORDER BY YourColumnNameHere DESC"<BR><BR>Your final query would like this:<BR>"SELECT * FROM Escalations<BR>ORDER BY YourSortColumn DESC"<BR><BR>Hope that helped :)<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
  •