Thanks fir the suggestions - I'll test them all. ___________________ Sent from my iPad 2 8)
On Sep 20, 2011, at 12:47 PM, "Robert Shubert" <[email protected]> wrote: > Dale, > > > > Something else to consider. > > > > It’s possible that the character in your database isn’t a single-quote, but > one of the other similar characters. > > > > See if you find the record with this statement: > > > > SELECT * from scientists where lname like ‘%’’%’ > > > > Robert > > > > From: Dale Graham [mailto:[email protected]] > Sent: Tuesday, September 20, 2011 10:25 AM > To: [email protected] > Subject: Witango-Talk: Searching names containing apostrophes > > > > If I search on something like this > > > > Prud'homme > > > > no results are returned, despite the fact that this person (Robert > Prud'homme) exists in the database > > > > (Note that I am using <@upper to keep this case insensitive). I > created this by taking the lname variable and making it upper case and > searching with the custom column. > > > > But looking at the sql statement, I can see why it failed. > > > > SELECT DISTINCT S1.SCID FROM SCIENTISTS S1,IPID_ORID_SCID I2 WHERE > (upper(S1.lname)='PRUD''HOMME' AND upper(S1.fname)='ROBERT' AND I2.ORID=?) > AND ((S1.SCID=I2.SCID)) > > > > > However, I have tried searching using <@var request$lname encoding=sql> but > that didn't fix the issue. And I cannot figure out how to do a replace of an > apostrophe (e.g., single quote) with <@sq>. > > > > I also tried getting the data to be searched (being parsed from XML files) > and setting the variable to encoding=sql initially as well. No joy. > > > > Ideas? Fixes? > > > > > > 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.
