duda con consulta

[Reynier]

Tengo la siguiente consulta:

Código PHP:

  SELECT *, COUNT(idpost) AS cant FROM jcgrm_preguntas WHERE idforo='".$show['idforo']."' GROUP BY idforo, idpost  
   

pero me da este error:

Warning: mssql_query() [function.mssql-query]: message: Column 'jcgrm_preguntas.idcat' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. (severity 16) in d:\WWW\www\includes\mainfunctions.php on line 666

Warning: mssql_query() [function.mssql-query]: message: Column 'jcgrm_preguntas.nick' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. (severity 16) in d:\WWW\www\includes\mainfunctions.php on line 666

Warning: mssql_query() [function.mssql-query]: message: Column 'jcgrm_preguntas.asunto' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. (severity 16) in d:\WWW\www\includes\mainfunctions.php on line 666

Warning: mssql_query() [function.mssql-query]: message: Column 'jcgrm_preguntas.mensaje' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. (severity 16) in d:\WWW\www\includes\mainfunctions.php on line 666

Warning: mssql_query() [function.mssql-query]: message: Column 'jcgrm_preguntas.fecha' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. (severity 16) in d:\WWW\www\includes\mainfunctions.php on line 666

Warning: mssql_query() [function.mssql-query]: message: Column 'jcgrm_preguntas.visitas' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. (severity 16) in d:\WWW\www\includes\mainfunctions.php on line 666

Warning: mssql_query() [function.mssql-query]: Query failed in d:\WWW\www\includes\mainfunctions.php on line 666
No se pudo ejecutar la consulta SELECT *, COUNT(idpost) as cant FROM jcgrm_preguntas WHERE idforo='1' GROUP BY idforo, idpost. Error: Column 'jcgrm_preguntas.visitas' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

sabe alguien si tengo que agrupar por todos los campos que contiene esa tabla donde estoy haciendo el COUNT o que es lo que pasa?
Estoy trabajando con PHP y MSSQL

Salu2

[Teri]

Sin entrar en mucho detalle... las consultas de GROUP BY no admiten sacar asterisco, si necesitas sacar todos los campos de tabla, caben varias opciones

Incluir todos los campos en el GROUP BY, o sacarlos conk funciones de agregado tales com Min, Max, etc..., o mejor aún sacar en la SELECT sólo aquellos campos que de verdad necesites


Un saludo