[Vtigercrm-developers] Web Services Javascript

[Christophe Humbert]

Hello

I am trying to use inside an auto-complete...but this somehow working but
it is not really perfect..

If anyone can have a look...


Thanks in advance


Christophe Humbert
*IT Program Manager*
*CoProcess S.A*
+352 691 391 974
+33 6 50 09 48 88
Skype: chris.e.humbert


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

> 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/20150523/5ec07dbc/attachment.html>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150523/5ec07dbc/attachment-0001.html>