No a problem, I had to chuckle when after I posted my reply, Dave's came in and I realized we had said almost the exact same solution :-)
I am curious (Because I am looking at MySQL and PostgreSQL) what was your solution? Is there a upper() function in PostgreSQL? Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Latest downloads & List Archives @ http://www.witango.ws -----Original Message----- From: [EMAIL PROTECTED] [mailto:owner-witango-talk@;witango.com] On Behalf Of Jeffrey Bohmer Sent: Thursday, October 17, 2002 10:39 AM To: Multiple recipients of list witango-talk Subject: RE: Witango-Talk: Case insensitive search in search action 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 ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
