Scusate la mia infinita ignoranza in materia ma non riesco a farla funzionare dove è che sbaglio??


<%
18 Set rsCount = Server.CreateObject ("ADODB.Recordset")
19 Set rs = Server.CreateObject ("ADODB.Recordset")
20 SQLCOUNT = "SELECT MAX(ID) AS 'totali' FROM Offerta"
21 rsCount.ActiveConnection = MM_conn_offerte_STRING
22 rsCount.CursorType = adOpenStatic
23 rsCount.Open SQLCOUNT, MM_conn_offerte_STRING
24 SQL = "SELECT COUNT(ID) AS 'numero' FROM SERIE WHERE contatore=" & (rsCount("totali") - 1)
25 rs.ActiveConnection = MM_conn_offerte_STRING
26 rs.CursorType = adOpenStatic
27 rs.Open SQL, MM_conn_offerte_STRING
%>

errore:
Microsoft OLE DB Provider for ODBC Drivers errore "80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/website/index.asp, riga 23