This is the method I use for any database. Wayne is using the "builder" (or whatever it's called these days!) and not writing the SQL call, so it may not be an option.
-- sent from my iPhone4 -- Beverly Voth -- On Mar 31, 2011, at 11:44 PM, "Robert Shubert" <rshub...@tronics.com> wrote: > Just FYI - I tested this method and it works as expected. Robert > > -----Original Message----- > From: Shannon Henderson [mailto:shend...@reed.edu] > Sent: Thursday, March 31, 2011 4:53 PM > To: Witango-Talk@witango.com > 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 > shend...@reed.edu > > 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 lists...@witango.com >> with "unsubscribe witango-talk" in the body. >> >> > > > ---------------------------------------- > > To unsubscribe from this list, please send an email to lists...@witango.com > with "unsubscribe witango-talk" in the body. > > > > ---------------------------------------- > > To unsubscribe from this list, please send an email to lists...@witango.com > with "unsubscribe witango-talk" in the body. > ---------------------------------------- To unsubscribe from this list, please send an email to lists...@witango.com with "unsubscribe witango-talk" in the body.
