ordine visualizzazione database

[omar_17]

come faccio a visualizzare i campi del database dall'ultimo inserito al primo?

cstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../../mdb-database/redl-news.mdb") 
Set objConn=Server.CreateObject("ADODB.Connection")
objConn.Open cstring
	  Dim objRec         
	  Set objRec = Server.CreateObject ("ADODB.Recordset")
	  objRec.open "newsred", objConn, adOpenKeyset, _
		  adLockReadOnly, adCmdTable

	  While Not objRec.EOF
	      Response.Write(objRec("titolo"))

	      Response.Write(objRec("data"))
	     
	      Response.Write(objRec("news"))
	      objRec.MoveNext
	  Wend
	
	  objRec.Close
	  Set objRec = Nothing
	  
	  objConn.Close
	  Set objConn = Nothing

[Roby_72]

Fai prima e meglio ad usare una query standard:

sql = "SELECT * FROM newsred ORDER BY id DESC"

Roby