form server open source
how do i display the records in reverse order on my asp page?
here is the code i have so far and it displays the records but i need the newest record to display first
<%
Dim rs, data_source, no
no = 0
data_source = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
Server.MapPath("post.mdb")
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "Comment", data_source
While Not rs.EOF
Response.Write "
"
no = no + 1
rs.MoveNext
Wend
rs.Close
Set rs = Nothing
Response.Write "
Total Records Found : " & no
%>
use this
rs.open "select * from comment order by name desc",data_source
or
rs.open "select * from comment order by id desc",data_source
[phpbay]form server open source, 30, "11211"[/phpbay]
[phpzon]form server open source, 5, Electronics[/phpzon]
Really Simple Web Content Management with Alfresco