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

[lajeesh k]

Hello,

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 ?




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