Re: CF newbie: Search Non Case Sensitive Results

[Mark Armstrong]

PostgreSQL on Apache 2 - I didn't have this issue on the old SQL 7 on 
NT DB. I'll check the settings!

Thank you!
Mark
On May 13, 2005, at 12:07 PM, Daniel Elmore wrote:
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: list@dfwcfug.org
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 list@dfwcfug.org
To unsubscribe:
   http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
   http://www.dfwcfug.org/form_MemberRegistration.cfm


----------------------------------------------------------
To post, send email to list@dfwcfug.org
To unsubscribe:
   http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
   http://www.dfwcfug.org/form_MemberRegistration.cfm

----------------------------------------------------------
To post, send email to list@dfwcfug.org
To unsubscribe: 
  http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe: 
  http://www.dfwcfug.org/form_MemberRegistration.cfm