try upcasing the comparison fields.
IE
WHERE
Ucase(proj_name) LIKE '%#Ucase(projcontains)#'
the first Ucase is whatever uppercase function your database supports.
Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 11:54 AM
To: [EMAIL PROTECTED]
Subject: FindNoCase Function
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.
------------------------------------------------------------------------------
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.
