Syntax error in GROUP BY clause

[zeweb]

Come posso cambiare una SQL del tipo

strSQL="SELECT * from products where new=true AND tip_UK<>'RFID' AND online=true ORDER BY model ASC"

in una che mi raggruppi per tip_UK

strSQL="SELECT * from products where new=true AND tip_UK<>'RFID' AND online=true GROUP BY tip_UK ASC"

mi da errore:
Syntax error in GROUP BY clause.
/wireless/uk/news.asp, line 125

devo indicare i campi che recupero invece di * ?

<% 
Set objConn = Server.CreateObject("ADODB.Connection") 
set rs=server.CreateObject("ADODB.recordset")
objConn.Open strCon
strSQL="SELECT * from products where new=true AND tip_UK<>'RFID' AND online=true GROUP BY tip_UK ASC" 
rs.Open strSQL, objConn,3,3
	
recordsperpage=5
rs.pagesize=recordsperpage
Pages=request.querystring("pagina")
if (len (Pages)>0 and isnumeric(Pages)) then
Pages=clng(Pages)
else
Pages=1
end if
%>

Grazie

[optime]

hai messo un ASC dopo la GROUP BY...

[zeweb]

sì ma ora mi dice

Cannot group on fields selected with '*'.

[optime]

giusto. elenca i campi

[zeweb]

nulla adesso l'errore è diverso

You tried to execute a query that does not include the specified expression 'id' as part of an aggregate function.

<% 
Set objConn = Server.CreateObject("ADODB.Connection") 
set rs=server.CreateObject("ADODB.recordset")
objConn.Open strCon
strSQL="SELECT id,model,tip_uk,modulation,titolo_UK,comp,descrizione_UK from products where new=true AND tip_UK<>'RFID' AND online=true GROUP BY tip_UK" 
rs.Open strSQL, objConn,3,3
	
recordsperpage=5
rs.pagesize=recordsperpage
Pages=request.querystring("pagina")
if (len (Pages)>0 and isnumeric(Pages)) then
Pages=clng(Pages)
else
Pages=1
end if
%>

[optime]

nella group by vanno elencati tutti i campi... usi access?

[zeweb]

sì

strSQL="SELECT id,model,tip_uk,modulation,titolo_UK,comp,descrizione_UK,code,new from products where new=true AND tip_UK<>'RFID' AND online=true GROUP BY tip_UK"

specified expression 'id' as part of an aggregate function.

[optime]

ti conviene allora progettare la query con access, cosi' vedi bene i meccanismi....

[zeweb]

a saperlo fare....