Changeset 1166

Timestamp:

11/18/08 17:26:01 (2 months ago)

Author:

laurentj

Message:

ticket #738: error with postgresql and lastInsertId in the aclgroup command.

Files:

• branches/1.0.x/lib/jelix-scripts/commands/aclgroup.cmd.php (modified) (1 diff)
• trunk/lib/jelix-scripts/commands/acl2group.cmd.php (modified) (2 diffs)
• trunk/lib/jelix-scripts/commands/aclgroup.cmd.php (modified) (1 diff)

branches/1.0.x/lib/jelix-scripts/commands/aclgroup.cmd.php

@@ -113 +113 @@
-
-        $cnx->exec($sql);
-);
+'jacl_group_id_aclgrp_seq'); // name of the sequence for pgsql
-        echo "OK. Group id is: ".$id."\n";
-    }

trunk/lib/jelix-scripts/commands/acl2group.cmd.php

@@ -184 +184 @@
-
-        $cnx->exec($sql);
-);
+'jacl2_group_id_aclgrp_seq'); // name of the sequence for pgsql
-        echo "OK. Group id is: ".$id."\n";
-    }
@@ -308 +308 @@
-        $sql.=$login.',2, '.$login.')';
-        $cnx->exec($sql);
-);
+'jacl2_group_id_aclgrp_seq'); // name of the sequence for pgsql
-
-        $sql="INSERT INTO jacl2_user_group (login, id_aclgrp) VALUES(".$login.", ".$id.")";

trunk/lib/jelix-scripts/commands/aclgroup.cmd.php

@@ -113 +113 @@
-
-        $cnx->exec($sql);
-);
+'jacl_group_id_aclgrp_seq'); // name of the sequence for pgsql
-        echo "OK. Group id is: ".$id."\n";
-    }