[Vtigercrm-developers] Web Services Javascript

[Christophe Humbert]

Hello Alan,

now it is even working with the @...Should stop working night and days....

I need to find a way to loop through all results now...

Christophe Humbert



On Wed, May 20, 2015 at 2:16 PM, Christophe Humbert <
chrissc.humbert at gmail.com> wrote:

> 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/0829357f/attachment.html>