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.
