www.webdeveloper.com
Results 1 to 2 of 2

Thread: ORDER BY field_name ASC (sorting Access DB results)

  1. #1
    Join Date
    Dec 2007
    Posts
    39

    ORDER BY field_name ASC (sorting Access DB results)

    Hi Developers,

    I am using a poll from which I can get the poll results from my Access Db properyl by the following code:

    Code:
    <td width="100%">
    <%DO UNTIL rsAnswer.EOF%>
    <%percent = FormatPercent(rsAnswer("total_votes")/rsPoll("total_votes"),0)%>
    	      <table width="100%"  cellspacing="0" height="15">
    	        <tr>
    	          <td width="350" style="width: 125" class="style1" size="10px">
                         <%=rsAnswer("total_votes")%><span class="style2">Vote(s)</span> </td>
    	          <td width="350" style="width: 200" class="style4">
                        <img src="votes.gif" width="<%=percent%>" height="20" class="style5"> 
    	          </td>
    	          <td Align="right" class="style3" style="width: 125">
    	            <strong> <%=rsAnswer("answer")%></strong> 
    	          </td> 
    	        </tr>
    	      </table>
    <%rsAnswer.MoveNext%>
    <%LOOP%>
     </td>
    The code represents the results of the votes and also the total number of votes for each question. (variable total_votes)
    It works properly but what I am trying to achieve is to sort the results by the variable (total_votes) descending. I mean that the most voted question or result lies at the top and continues with the next most voted question in the next line.

    have been trying to sort it out with (ORDER BY total_votes ASC) at the end of %LOOP% but it did not work.

    Any comments about the correct usage of the code is appreciated.

    Thank you for your time & comments.

  2. #2
    Join Date
    Dec 2007
    Posts
    39
    By inserting the "ORDER BY total_votes ASC" into sql statement, it worked fine.

    Thanks all.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles