You don't use IN with wild-cards like %. Use prds.title LIKE
(<cfqueryparam cfsqltype="cf_sql_varchar" list="true"
value="%#keyword#%">)
IN is used to find matching values from a list, for example:
WHERE prds.title IN ('Hello','Testing','Values?')
You can use #quotedValueList(myVariable)# to get a list with items
surrounded by quotes.
Chris Peterson
Gainey IT
Adobe Certified Advanced Coldfusion Developer
-----Original Message-----
Sent: Wednesday, August 01, 2007 2:21 PM
To: CF-Talk
Subject: Re: Cfqueryparam and list
that's what i am trying... but its not working.
prds.title IN (<cfqueryparam cfsqltype="cf_sql_varchar" list="true"
value="%#keyword#%">)
>and prds.title IN (<cfqueryparam... )
>
>
>>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285089
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
