Cosa sbaglio in questa sintassi:?
codice:
sql = "SELECT ID_PRODOTTO, PRODOTTO FROM TBL_PRODOTTI GROUP BY PRODOTTO ORDER BY ID_PRODOTTO"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, cn, 3, 3
perchè restituisce Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'ID_PRODOTTO' as part of an aggregate function.