[Vtigercrm-developers] How to escape single quote in Vtiger Webservice

johnnyrockets johnb at newsreview.com
Wed Jul 8 22:54:37 GMT 2015


Is there a way to use a quote in a Vtiger Webservice query?
I can't seem to get this to work:
select * from Contacts where lastname='O\'Connor';
The error produced is
Request failed: QUERY_SYNTAX_ERROR
Syntax Error on line 3: token 's' Unexpected COLUMNNAME(s), expected one of:
SEMICOLON
Thanks,
Biz




--
View this message in context: http://vtiger-crm.2324883.n4.nabble.com/How-to-escape-single-quote-in-Vtiger-Webservice-tp16853.html
Sent from the vtigercrm-developers mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150708/c97af0bc/attachment.html>


More information about the vtigercrm-developers mailing list