[Vtigercrm-developers] Web Services Javascript

[Christophe Humbert]

Hello Alan,

you were right...this is the @ causing the issue :)

Thanks

Christophe Humbert



On Wed, May 20, 2015 at 11:10 AM, Alan Lord <alanslists at gmail.com> wrote:

> On 20/05/15 08:13, Christophe Humbert wrote:
>
>> "SELECT * FROM Contacts WHERE email like'%@gmail.com'";
>>
>
> two things:
>
> 1. You have no space between like and the '%@gmail.com'
> 2. Have you tried without the "@" symbol - it might be being treated as a
> special character..., e.g.
>
> > "SELECT * FROM Contacts WHERE email LIKE '%gmail.com'";
>
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150520/8a38ee9c/attachment.html>