I think you are using wrong Query name, this line should be... <cfset session.groupname = QuotedValueList(UserGroups.groupname)>
regards badal Tyagi HCL Perot Systems Noida, India -----Original Message----- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Monday, July 14, 2003 2:01 PM To: CF-Talk Subject: Code Errors with Coldfusion - Please Help ? Hi I would appreciarte it if someone on the list could try to help me solve this problem please, I am trying the following code against an Oracle database and it is returning the following error from this code ? <cfquery name="UserGroups" datasource="intranetv8"> SELECT * FROM usergroupmembership, groups WHERE UserID = #Session.ID# AND usergroupmembership.groupid = groups.groupid </cfquery> <cfset session.groupname = QuotedValueList(Groups.groupname)> <CFQUERY name="list" datasource="intranetv8"> SELECT * FROM itlinks WHERE linkarea='#URL.area#' AND ( security IN (#PreserveSingleQuotes(session.groupname)#) OR security = 'all' ) ORDER BY linkid desc </CFQUERY> Error Occurred While Processing Request Error Diagnostic Information An error occurred while evaluating the expression: session.groupname = QuotedValueList(groups.groupname) Error near line 14, column 7. -------------------------------------------------------------------------- Parameter 1 of function QuotedValueList which is now "groups.groupname" must be pointing to a valid query name The error occurred while processing an element with a general identifier of (CFSET), occupying document position (14:1) to (14:61) in the template file /usr/netscape/server4/docs/intranet/itintranet/itlinks/linksdetail.cfm. Date/Time: Mon Jul 14 09:32:44 2003 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Remote Address: 121.100.25.2 HTTP Referer: http://intranet.neath-porttalbot.gov.uk/itintranet/itlinks/links.cfm Query String: area=Emerging%20Technologies It looks as if it does not like these parts ? -------------- <cfset session.groupname = QuotedValueList(Groups.groupname) and security IN (#PreserveSingleQuotes(session.groupname)#) ---------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
