(#ListQualify(MyMultiPickValue, "'")#)

[mikey999]

I am trying to search a field based on a multi pick drop down search search. This works really well when the has the exact value in it. But is there a why yo do this while adding wild cards on.

For example this search

<CFQUERY Name="GetData" datasource="MyDataSource">
SELECT *
FROM Tagging
WHERE Tagging.TagName IN (#ListQualify(MyMultiPickValue, "'")#)
</CFQUERY>

may look like

SELECT *
FROM Tagging
WHERE Tagging.TagName IN (african,american)#)

it will pull up all records with africa and american but not records with like south american or souch africa

in a normal query you can fix this by adding %

like

AND Tagging.TagName LIKE '%#MyMultiPickValue#%'

is there any way to put a while card of the search value for this query ?

<CFQUERY Name="GetData" datasource="MyDataSource">
SELECT *
FROM Tagging
WHERE Tagging.TagName IN (#ListQualify(MyMultiPickValue, "'")#)
</CFQUERY>


thanks for your help in this matter
m

[Dan_Bracuk]

expect this to be slow.



select JustTheFieldsYouNeed
from tagging
where 1 = 1
and
(
<cfloop list = MyMultipickList index = "ThisItem">
tagname like '%ThisItem%'
or
</cfloop>
1 = 2
)

[mikey999]

thanks that did it 🙂