Hi! I need to extend an existing installation of reactor, used on a CMS-system, to include an accesscontroll system, implemented on a databaselevel.
The database is mssql, and we will implement the accesscontroll by joining against a tablevalued function. Example: SELECT f.* FROM dbo.getAccessibleElements (7, 0) acl INNER JOIN tblFoo f on f.fk_acl_guid = acl.guid WHERE 0 = 0 AND acl.access_mask > 0 This can easily be done in a gateway, but I don't see how it can be done in the record. Is it possible? Cheers, Oli -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
