Your database must be set to a case sensitive collation. What's your DB?
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark Armstrong Sent: Friday, May 13, 2005 12:01 PM To: [email protected] Subject: CF newbie: Search Non Case Sensitive Results Its seems by default searching records is case sensitive, how do I tell the search to ignore case? my search code: <cfquery datasource="datasource" name="getMembers"> SELECT * FROM members <cfif isDefined("search")> Where Lastname like '%#search#%' or firstname like '%#search#%' or homeAddress like '%#search#%' or workAddress like '%#search#%' or homeCity like '%#search#%' or workCity like '%#search#%' or homeState like '%#search#%' or workState like '%#search#%' or workZip like '%#search#%' or workphone like '%#search#%' or homephone like '%#search#%' or email like '%#search#%' or homeZip like '%#search#%' </cfif> Order By Lastname ASC </cfquery> thanks for any suggestions! mark ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
