Jochem Just run what you sent, no errors returned but do not think that parameter 2 is not working as it has again not been populated. I am using Coldfusion 4.5. What are the benefits of doing it your way ??
Queries UserGroups (Records=0, Time=27ms) SQL = SELECT * FROM usergroupmembership, groups WHERE UserID = 75 AND usergroupmembership.groupid = groups.groupid list (Records=3, Time=43ms) SQL = SELECT * FROM itlinks WHERE linkarea = :1 AND security IN (:2,:3) ORDER BY linkid DESC Query Parameter Value(s) - Parameter #1 = Database Development/Support Parameter #2 = Parameter #3 = all ----- Original Message ----- From: "Jochem van Dieten" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, July 14, 2003 1:55 PM Subject: Re: Code Errors with Coldfusion - Please Help ? > 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
