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
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
