What he's saying is this... in your code snippet:
<cfif len(arguments.orderKeyList)>
AND o.tablePK = <cfqueryparam value="#arguments.orderKeyList#"
cfsqltype="CF_SQL_INTEGER" list="Yes">
</cfif>
and the other one that uses the cfqueryparam where list="Yes"
you need to treat it as an IN clause instead of an EQUALS.
Here's an unparameterized example.
select *
from table
where ID in (3,5,2,6,1)
Until Later!
C. Hatton Humphrey
http://www.eastcoastconservative.com
Every cloud does have a silver lining. Sometimes you just have to do some
smelting to find it.
On Thu, Jun 12, 2014 at 11:14 PM, Matthew Smith <[email protected]>
wrote:
>
> How do you mean? Thanks! I tried a = as well... Didn't work either.
>
> > On Jun 12, 2014, at 23:03, LRS Scout <[email protected]> wrote:
> >
> >
> > Did you look up the sql "in"
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:370901
Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
