Devi sempre usare due recordset:

codice:
Set rsCount = Server.CreateObject ("ADODB.Recordset")
Set rs = Server.CreateObject ("ADODB.Recordset")
SQLCOUNT = "SELECT COUNT(ID) AS 'totali' FROM DATABASE"
Set rsCount.ActiveConnection = cn
rsCount.CursorType = adOpenStatic
rsCount.Open SQLCOUNT, cn
SQL = "SELECT COUNT(ID) AS 'numero' FROM SERIE WHERE contatore=" & (rsCount("totali") - 1)
Set rs.ActiveConnection = cn
rs.CursorType = adOpenStatic
rs.Open SQL, cn
Lele