I have the following text box on a form:
<CFINPUT TYPE="text" NAME="projcontains" SIZE="15">
<INPUT TYPE="Submit" VALUE="Find">
I can put the word "Fire" in the box and press "Find" using the following:
WHERE proj_name LIKE '%#projcontains#%'
and it finds all the correct projects. But if I put the word "fire", it
doesn't find anything. So I would like to do a non-case-sensitive search, I
have the following which is not working:
<CFQUERY NAME="GetContracts" DATASOURCE="Purchasing">
SELECT *
FROM pwcntrct
...various other CFIF statements
<CFIF projcontains IS NOT "">
WHERE proj_name LIKE '%#FindNoCase(projcontains, projcontains)#%'
</CFIF>
I'm not sure how to go about this since the "FindNoCase" function requires a
search string (projcontains) and a target string.
Sherry Zeiss
Infrastructure Support Services
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.
