mi da errore
Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/wireless/it/news.asp, line 158
su questa riga : rs.Open strSQL, objConn, 3,3
codice:<% 'APERTURA CONNESSIONE CON IL DATABASE SENZA DSN Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & server.MapPath("/fpdb/wire_products.mdb") strSQL="SELECT * FROM products where new='1' AND month(DateSF) = " & month(date()) & " ORDER BY tip_IT DESC" set rs=server.CreateObject("ADODB.recordset") rs.Open strSQL, objConn, 3,3 %>

Rispondi quotando