<%
'On Error Resume Next
connectionstring = "DRIVER={MySQL ODBC 3.51 Driver};DATABASE=Sqllol_5;SERVER=LOL;UID=LOL;PASSW ORD=LOL"
set objConn = server.createObject("ADODB.Connection")
objConn.Open connectionstring


SQL="SELECT COUNT(ID) as Conta FROM Articoli"


Set rec=objConn.Execute(SQL)

SQL="SELECT COUNT(*) as Conta2 FROM Articoli WHERE Canale='Flash'"

Set rec = Server.CreateObject("ADODB.Recordset")
Set rec=objConn.Execute(SQL)


%>
<%=rec("conta2")%>

<%=rec("conta")%>

Mi dice

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/varie/statistica.asp, line 40

In pratica devo contare prima tutti i record, poi solo quelli che hanno Canale=Flash

dov'è il problema?

Grazie