Just changed that line to what you suggested and am getting an Oracle error
Queries
UserGroups (Records=0, Time=26ms)
SQL =
SELECT * FROM usergroupmembership, groups WHERE UserID = 1
AND
usergroupmembership.groupid = groups.groupid
Error Occurred While Processing Request
Error Diagnostic Information
Oracle Error Code = 936
ORA-00936: missing expression
SQL = "SELECT * FROM itlinks WHERE linkarea='Emerging Technologies'
AND ( security IN () OR security = 'all' ) ORDER BY linkid desc"
Data Source = "INTRANETV8"
The error occurred while processing an element with a general
identifier of (CFQUERY), occupying document position (18:1) to (18:45) in
the template file
/usr/netscape/server4/docs/intranet/itintranet/itlinks/linksdetail.cfm.
Date/Time: Mon Jul 14 09:55:07 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
Please inform the site administrator that this error has occurred (be sure
to include the contents of this page in your message to the administrator).
----------------------------------------------------------------------------
----
----- Original Message -----
From: "Tyagi, Badal" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, July 14, 2003 9:46 AM
Subject: RE: Code Errors with Coldfusion - Please Help ?
> 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
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
