codice:<% 'Apri connessione conn strSQL="SELECT COUNT(*) AS tot_rec FROM tabella" set rs = server.createobject("adodb.recordset") rs.open strSQL, conn tot_rec = 0 if not rs.eof then tot_rec = rs("tot_rec") end if rs.close set rs = nothing if tot_rec > 19 then strSQL="DELETE * FROM tabella" conn.execute(strSQL) end if 'Chiudi connessione conn %>
Roby