% Dim thisURL, cnnl, openStr, SQL thisURL = Request.ServerVariables("PATH_INFO") Set cnn1 = Server.CreateObject("ADODB.Connection") openStr = "Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Domains\centrotradizioneorale.net\db\maggio.mdb" cnn1.Open openStr,"","" sql = "SELECT url, hitcnt " & _ "FROM hitcounts " & _ "WHERE url = '" & thisURL & "';" Set rsHits = Server.CreateObject("ADODB.Recordset") rsHits.Open sql, cnn1, adOpenDynamic, adLockPessimistic, adCmdText If rsHits.EOF Then rsHits.AddNew rsHits("url") = thisURL curCount = 1 Els curCount = rsHits("hitcnt") + 1 End If rsHits("hitcnt") = curCount rsHits.update rsHits.Close Set rsHits = Nothing ora = now() SQL = "Insert Into viste (pagina, Data) Values('"&thisURL&"', '"&ora&"')" cnn1.Execute(SQL) cnn1.Close Set cnn1 = Nothing %>