<%@ Page Language="vb" Debug="true" %> <% @Import NameSpace="System.Data" %> <% @Import NameSpace="System.Data.SQLClient" %> <% @Import NameSpace="System.Diagnostics.Debug" %> <% @Import Namespace="System.Web.Mail" %> <% @Import Namespace="System.Text.RegularExpressions" %> <% @Import NameSpace="System.Data.OleDb" %> <%@ Import namespace="System.IO" %> <%@ Import namespace="System.Net" %> <% Dim Last_Id = 0 Dim Last_Id_Tot = 0 Dim counter = 0 Dim Type_Message = Request.QueryString("Type_Message") Response.Write ("


Messaggi



") Response.Write ("") sqlConn.Open() sqlComm = New SqlCommand("SELECT TOP 100 Messaggi.Id, Type_Message, Data_Messaggio, Messaggio FROM Messaggi WHERE Messaggi.Id_Utente = '"& Id_This_User &"' ORDER BY Data_Messaggio DESC ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() counter = counter + 1 If counter = 1 Then Last_Id_Tot = (r("Id")) End If Last_Id = (r("Id")) Response.Write ("") Response.Write ("") End While r.Close() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Messaggi WHERE ID < '"& Last_Id &"' AND Id_Utente = '"& Id_This_User &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Utenti SET Last_Id = " & Last_Id_Tot & " WHERE Id = '"& Id_This_User &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() %>

") Response.Write (r("Data_Messaggio")) Response.Write ("

") Response.Write ("") Response.Write (r("Messaggio")) Response.Write ("