[Vtigercrm-developers] Webservice query having single quote in where condition fails

lajeesh k lajeeshk at gmail.com
Tue Oct 16 09:22:43 GMT 2018


I have a query like this

select * from Experience where companyname='Pick'n Pay Retailers'

since the company name Pick'n Pay Retailers contain 'n the query fails.

I have tried addslashes, sitll it fails .

Any idea to escape this single quote ?

Freelance developer / entrepreneur
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20181016/d4f256cd/attachment.html>

More information about the vtigercrm-developers mailing list