<%@ 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" %>


Gilda


 
<% Dim Date_Count = Format_Date("15/09/2005 4.49.10") Dim Counter = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT * FROM Utenti JOIN Pianeti ON Utenti.Username = Pianeti.Proprietary AND Pianeti.Is_Principal = 1 WHERE Data_Last_Access < '"& Date_Count &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Counter = Counter + 1 %><%=Counter%> - <%=r("Username")%>: <%=r("Data_Last_Access")%>
<% End While r.Close() sqlConn.Close() %>