Re: [SQL] Stored procedures and "pseudo" fields

2004-08-10 Thread Christoph Haller
Lars Erik Thorsplass wrote: > On Tue, 20 Jul 2004 09:45:06 -0600, Scott Marlowe <[EMAIL PROTECTED]> wrote: > > > Kinda like this: > > > > > > SELECT *, acl_check( objects.obid, ) AS mode FROM objects > > > WHERE mode > 0; > > > > Here's the problem. In order to do the select, the query first need

Re: [SQL] Stored procedures and "pseudo" fields..

2004-07-20 Thread Markus Bertheau
Ð ÐÑÑ, 20.07.2004, Ð 15:57, Tomasz Myrta ÐÐÑÐÑ: > On 2004-07-20 15:34, UÅytkownik Lars Erik Thorsplass napisaÅ: > > My stored procedure "acl_check()" takes two integers as parameters. > > Param1 is the object id to check acl on, Param 2 is the object id of > > the user currently using the system. T

Re: [SQL] Stored procedures and "pseudo" fields..

2004-07-20 Thread Tomasz Myrta
On 2004-07-20 15:34, UÅytkownik Lars Erik Thorsplass napisaÅ: My stored procedure "acl_check()" takes two integers as parameters. Param1 is the object id to check acl on, Param 2 is the object id of the user currently using the system. The procedure returns a positive number (1 or 3 ) if you have s

[SQL] Stored procedures and "pseudo" fields..

2004-07-20 Thread Lars Erik Thorsplass
I also posted this to the general list, which might not have been a suitable forum. -- I have recently ventured into the exciting world of stored procedures, but I have now become lost. Background: Am currently working on access control in a web application. My goal is to process access control