Ian, > <CFQUERY DATASOURCE="#Application.DSN#" NAME="Security"> > Hope that this is in CFMX, otherwise you need to be looking at CFLOCK.... ;o)
> > For example I run a query to return a list of documents in my database table. > > Some of the records are available to view to everybody, however some of the records > are only available to view by TEAM 1 and some are only avaialble to TEAM 2. > > How can this type of personalization be built into the pages? > You need to query your database to find out which "teams" that user belongs to and then only select the documents that are available to everyone or those groups to which this particular user belongs to. Basically, just grab the users teams when they log in and store them in a session variable as well... Hope this helps point you in the right direction. Regards Stephen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
