Ian Vaughan wrote: > > <cfquery name="UserGroups" datasource="intranetv8"> > SELECT * FROM usergroupmembership, groups WHERE UserID = #Session.ID# > AND > usergroupmembership.groupid = groups.groupid > </cfquery>
<cfset allowedUserGroupList = ArrayToList(UserGroups["groupname"]) & ",all"> <CFQUERY name="list" datasource="intranetv8"> SELECT * FROM itlinks WHERE linkarea = <cfqueryparam cfsqltype="cf_sql_varchar" value="#URL.area#"> AND security IN (<cfqueryparam cfsqltype="cf_sql_varchar" value="#allowedUserGroupList#" list="yes">) ORDER BY linkid DESC </CFQUERY> Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
