Oracle. One of my colleagues just told me that the SQL statement generated by Terascript was correct. Now I need to check and see if I just missed something in reviewing the debug!
___________________ Sent from my iPad 2 8) On Sep 20, 2011, at 11:25 AM, <[email protected]> wrote: > Hi, > > what database are you using? > > Is "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))" coming from the debug portion of the page? > > Ted > ---- Dale Graham <[email protected]> wrote: >> 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.
