migracion III - El retorno de Charly Mendez

From: Date: Fri, 17 Nov 2000 17:40:02 +0000
Subject: migracion III - El retorno de Charly Mendez
Groups: php.general.es 
Request: Send a blank email to general-es+get-3957@lists.php.net to get a copy of this message
Un nuevo problema para David Vincent: Tiro en mi aplicacion PHP este query que en MySQL funcionaba joya, chiche-bombom y el benemerito PostgrSQL me dice: Database error: Invalid SQL: SELECT site.id AS id, uri, title, descr, country_id, SUM(score) AS scoresum, cid FROM site, site_temp WHERE site.id = site_temp.id AND session = '91b3fd0e2dea5a822a58e4c5463efa0f' GROUP BY site_temp.id ORDER BY scoresum DESC limit 15 PostgreSQL Error: 1 (ERROR: Attribute site.id must be GROUPed or used in an aggregate function ) Yo NO quiero agrupar por site.id.....que hago ??? Gracias Javier

« previous php.general.es (#3957) next »