BusinessObjects Board

QueryBuilder escape character

sdk development
#1

So this should be a simple thing.
We are running into reports and path names that users have put ’ in the names.

This, of course, messes up any query builder query like:
SELECT * FROM CI_INFOOBJECTS WHERE SI_NAME=‘O’Conner Testing’

I tried to escape it with a double quote instead like:
SELECT * FROM CI_INFOOBJECTS WHERE SI_NAME=“O’Conner Testing”

But for some reason, it won’t return the result as it can’t find it.

Is there a universal escape character I have forgotten about?

Thanks in advance.

ntruhan (BOB member since 2015-07-14)

#2

Double single quotes:

SELECT * FROM CI_INFOOBJECTS WHERE SI_NAME='O''Conner Testing'

joepeters :us: (BOB member since 2002-08-29)