Thanks Dave and Ben, I didn't know about the custom column in search actions.
- Jeff >You could convert both the column reference and postarg to upper case or >lower case. >Specify a custom column reference in your search criteria and enter >upper(colName) = <@upper <@arg argName>>. >This assumes of course that PostgreSQL supports the upper() function. > >Dave Shelley > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:owner-witango-talk@;witango.com]On Behalf Of Jeffrey Bohmer >Sent: Wednesday, October 16, 2002 10:00 PM >To: Multiple recipients of list witango-talk >Subject: Witango-Talk: Case insensitive search in search action > > > >Is there a way to create a case insensitive search in a search action >instead of using a DirectDBMS action? > >I want the user input to match regardless of case, so that 'blue' would >match 'blue' and 'Blue' and 'BLUE', etc. I'm using PostgreSQL, which is >case sensitive and cannot really be made case insensitive. I have a bunch >of search actions converted from FMP, which is case insensitive, and would >like to avoid re-creating them as DirectDBMS actions. > >Witango 5, iODBC, Mac OS X. > >TIA, >- Jeff >-- > >Jeff Bohmer >VisionLink, Inc. >_________________________________ >303.402.0170 >www.visionlink.org >_________________________________ >People. Tools. Change. Community. >________________________________________________________________________ >TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > >________________________________________________________________________ >TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body -- Jeff Bohmer VisionLink, Inc. _________________________________ 303.402.0170 www.visionlink.org _________________________________ People. Tools. Change. Community. ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
