BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

QueryBuilder escape character


 
Search this topic... | Search SDK (VBA/ASP/JSP)... | Search Box
Register or Login to Post    Forum Index -> SDK (VBA/ASP/JSP)  Previous TopicPrint TopicNext Topic
Author Message
ntruhan
Forum Member
Forum Member



Joined: 14 Jul 2015

Posts: 9



PostPosted: Mon Apr 06, 2020 6:28 pm 
Post subject: QueryBuilder escape character

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.
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6696
Location: Connecticut, USA


flag
PostPosted: Tue Apr 07, 2020 5:49 am 
Post subject: Re: QueryBuilder escape character

Double single quotes:
Code:
SELECT * FROM CI_INFOOBJECTS WHERE SI_NAME='O''Conner Testing'
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> SDK (VBA/ASP/JSP)  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0271 seconds using 17 queries. (SQL 0.0026 Parse 0.0008 Other 0.0236)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo