QofQ is case sensitive. So if you search for name LIKE '%Alanis%', it is NOT the same as searching for '%alanis%', or '%aLaNiS%'. The force it to be case-INsensitive, use a couple of functions:
SELECT * FROM qryResult WHERE lower(name) LIKE '%#lCase(form.findThis)#%' Hope that helps. On 2/10/07, Bob Imperial <[EMAIL PROTECTED]> wrote: > > Thanks again for the help on this Gert! I've setup my output but I ran > into > something I'm not sure of the syntax on how to fix this. When passing the > search criteria via my form variable, it only returns exact matches in > case......here's what I have setup: > > <cfdirectory action="LIST" directory="D:\wwwsites\mysite\#ThisDir#\" > name="qryResult" > filter="#ThisFilter#" recurse="Yes"> > <cfquery name="getFile" dbtype="query"> > Select * from qryResult Where name Like '%#form.findThis#%' > </cfquery> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269441 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
