Modificare il file:
\Buoni_Spesa_2015\Leggi.asp
<%@LANGUAGE = VBScript%> <% Dim DBConn,strconn set dbconn=server.createobject("ADODB.connection") strconn="Provider = Microsoft.Jet.OLEDB.4.0; Data Source =" & Server.MapPath ("/mdb-database/Buoni_Spesa_2015.mdb") dbconn.open strconn Dim objRS Set objRS = Server.CreateObject("ADODB.Recordset") RecordsPerPagina = 100 page = Request("page") %> <html> <head> <title>Elenco Buoni Spesa Emessi</title> </head> <body> <h1>Elenco Buoni Spesa Emessi</h1> <p> <% if page="" then page=1 strSQL = "SELECT * FROM Buoni_spesa order by N_Buono_ID ASC" objRS.open strSQL, DBConn, 1 objRS.PageSize = RecordsPerPagina objRS.AbsolutePage = page If objRS.Eof=True or objRS.Bof=True then Response.Write "<P>Nessun risultato trovato</P>" Else Response.Write ("<center><table border=1><tr><th bgcolor=lightyellow>N Buono</th><th bgcolor=lightyellow>Cognome Nome</th><th bgcolor=lightyellow>Importo</th><th bgcolor=lightyellow>Durata</th><th bgcolor=lightyellow>Titolare</th><th bgcolor=lightyellow>Scade</th><th bgcolor=lightyellow>Emesso</th><th bgcolor=lightyellow>Chiuso</th></tr>") For i=1 to RecordsPerPagina if Not objRS.EOF then Response.Write("<tr><td>" & objRS("N_Buono_ID") & "</td>") Response.Write("<td>" & objRS("Cognome_Nome") & "</td>") Response.Write("<td>" & objRS("importo") & "</td>") Response.Write("<td>" & objRS("durata") & "</td>") Response.Write("<td>" & objRS("titolare") & "</td>") Response.Write("<td>" & objRS("Scade") & "</td>") Response.Write("<td>" & objRS("emesso") & "</td>") Response.Write("<td>" & objRS("chiuso") & "</td></tr>") objRS.MoveNext end if Next Response.Write ("</table></center>") End if 'Response.Write "<P><B>Pagine:</B> " 'For pag=1 to objRS.PageCount ' ' Response.Write "<A href='default.asp?page=" & pag & "'>" ' ' Response.Write pag ' ' Response.Write "</A> " ' 'Next 'Response.Write "</P>" %> </p> <p> </p> <p><a href="index.html"><img src="images/Esci.png" width="90" height="90"></a></p> </body> </html> <% objRS.Close Set objRS=Nothing DBConn.Close Set DBConn=Nothing %>
[
Íàçàä
]