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.
