<%@ 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 Data_Sett = Format_Date(Datetime.now.AddDays(-30)) Data_sett = replace(Data_sett,".",":") sqlConn.Open() sqlComm = New SqlCommand("SELECT COUNT(*) as Conto FROM Messaggi WHERE Data < '"& Data_Sett &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() response.write (r("conto")) End While r.Close() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Messaggi WHERE Data < '"& Data_Sett &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() %>