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

[joe at tsolucio.com]

As per definition, you have to use two:

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




El 2018-10-16 11:22, lajeesh k escribió:
> 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
> _______________________________________________
> http://www.vtiger.com/