Changeset 1002

Timestamp:

06/25/08 21:32:35 (2 months ago)

Author:

laurentj

Message:

ticket #630: bad sql query in jacl2 admin module when using postgresql. p=nuks

Files:

trunk/lib/jelix-admin-modules/jacl2_admin/controllers/users.classic.php

r873	r1002
56	56	} elseif($grpid == -1) {
57	57	//only those who have no groups
58		$sql = 'SELECT login, count(id_aclgrp) as nbgrp FROM jacl2_user_group
59		GROUP BY login HAVING nbgrp < 2 ORDER BY login';
	58	if($cnx->dbms != 'pgsql') {
	59	// with MYSQL 4.0.12, you must use an alias with the count to use it with HAVING
	60	$sql = 'SELECT login, count(id_aclgrp) as nbgrp FROM jacl2_user_group
	61	GROUP BY login HAVING nbgrp < 2 ORDER BY login';
	62	} else {
	63	// But PgSQL doesn't support the HAVING structure with an alias.
	64	$sql = 'SELECT login, count(id_aclgrp) as nbgrp FROM jacl2_user_group
	65	GROUP BY login HAVING count(id_aclgrp) < 2 ORDER BY login';
	66	}
	67
60	68	$cnx = jDb::getConnection($p);
61	69	$rs = $cnx->query($sql);
62		$usersCount = -1;
	70	$usersCount = $rs->rowCount();
63	71	} else {
64	72	//in a specific group

Download in other formats: Unified Diff Zip Archive