SF.net SVN: ledger-smb:[3198] trunk/sql/modules/admin.sql

[..hidden..]

Revision: 3198
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3198&view=rev
Author:   einhverfr
Date:     2011-06-03 02:38:01 +0000 (Fri, 03 Jun 2011)

Log Message:
-----------
Erik's patch to correct user creation

Modified Paths:
--------------
    trunk/sql/modules/admin.sql

Modified: trunk/sql/modules/admin.sql
===================================================================
--- trunk/sql/modules/admin.sql	2011-06-03 02:36:57 UTC (rev 3197)
+++ trunk/sql/modules/admin.sql	2011-06-03 02:38:01 UTC (rev 3198)
@@ -358,8 +358,7 @@
             
             insert into user_preference (id) values (v_user_id);
 
-            select * from entity_employee where entity_id = in_entity_id;
-            IF NOT FOUND THEN
+            IF NOT exists(SELECT * FROM entity_employee WHERE entity_id = in_entity_id) THEN
                 INSERT into entity_employee (entity_id) values (in_entity_id);
             END IF;
             -- Finally, issue the create user statement


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.