Marcin o2.pl wrote:

...

CREATE FUNCTION lms_current_user() RETURNS int(11) NO SQL RETURN @lms_current_user;

CREATE VIEW customersview AS SELECT c.* FROM customers c WHERE NOT EXISTS ( SELECT 1 FROM customerassignments a JOIN excludedgroups e ON (a.customergroupid = e.customergroupid) WHERE e.userid = lms_current_user() AND a.customerid = c.id)

zrob te dwa zapytania i zobacz jaki bedzie blad

czy "lms_current_user" mam zamienić na swojego usera ?

nie, wpisz dokładnie tak jak jest -- Aleksander 'A.L.E.C' Machniak http://alec.pl gg:2275252 LAN Management System Developer http://lms.org.pl _______________________________________________ lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms