Just FYI - I tested this method and it works as expected. Robert -----Original Message----- From: Shannon Henderson [mailto:[email protected]] Sent: Thursday, March 31, 2011 4:53 PM To: [email protected] Cc: Wayne Irvine Subject: Re: Witango-Talk: JDBC and case sensitive searching
Have you tried using the upper or lower() functions in sql? Something like this: select * from some_table where lower(the_field) = '<@lower str="<@arg blah>">' or this: select * from some_table where upper(the_field) = '<@upper str="<@arg blah>">' ------------------------ Shannon Henderson Web Support Services Reed College Portland, Oregon 503/517-7745 [email protected] On 3/30/2011 10:14 PM, Wayne Irvine wrote: > I'm finding it hard work making allowances for JDBCs fussiness. All my code > accepts search criteria such as: > > nsw > > And finds records that contain: > > nsw, NSW, and even nSw. > > Not with JDBC. IT MUST BE EXACT! > > At present I am making a new field for every field that is searched and > making it equal to a lowercase version. I append 'LC' onto the field name. > > Then when I search it I user the<@LOWER> tag on the arg. Hence it will work > as it always used to. > > This is fine on a search that looks at four fields but a tad arduous (and > damn annoying) on one that searches 100 fields. > > I'm pretty sure I'm not the first to face this frustration. What are the > methods used to cope with this and why is JDBC more primitive that FileMaker? > > Wayne Irvine > > ---------------------------------------- > > To unsubscribe from this list, please send an email to [email protected] > with "unsubscribe witango-talk" in the body. > > ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body.
