+ Start a Discussion
LukeLuke 

Malformed query when asking for single quote.

Ok, here is the problem I'm having.  I run the following query on Account table:

 

select Name, Id from Account where Name='O'Neill, Eric 19046894'

Am guessing that the problem arises because of the single quote after O.  I just wonder how you guys dealt with this problem...  The number is an ID from my DB.

Thanks for your help.

Lukasz

BobbyJoeBobbyJoe
I am having the same issue, have you figured a workaround yet or recieved a solution?
djordandjordan

I found this syntax works fine

select id, .. from contact where lastName = 'O\'Connor'

 

D.