Why are you even doing a PreserveSingleQuotes if you have a QuotedValueList
function already there? I'm not entirely sure so somebody else correct me
if I'm wrong but you don't need the PreserveSingleQuotes at all there, only
the QuotedValueList function. Try it.
Andrew Hewitt
Web Application Developer
webworld studios, inc.
----- Original Message -----
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 16, 2000 7:22 AM
Subject: QuotedValueList in a CFQuery
> Am I going mad? I just tried doing;
>
> <cfquery name="myQuery" datasource="myDSN">
> select *
> from myTable
> where myField in
> (#PreserveSingleQuotes(QuotedValueList(myFirstQuery.myFirstField))#)
> </cfquery>
>
> This produces a JIT error, but when I try it like this;
>
> <cfset myList=QuotedValueList(myFirstQuery.myFirstField)>
> <cfquery name="myQuery" datasource="myDSN">
> select *
> from myTable
> where myField in (#PreserveSingleQuotes(myList)#)
> </cfquery>
>
> It works just fine
>
> The error it produces when the QuotedValueList is inside the query is;
> Invalid parser construct found on line 68 at position 48. ColdFusion was
> looking at the following text:
>
> QuotedValueList
> Invalid expression format. The usual cause is an error in the expression
> structure.
>
> I'm running CF4.5.1 on NT Server4 (SP6a) and IIS4
>
> Anyone got a decent answer???
>
> Philip Arnold
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **********************************************************************
>
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
