[Vtigercrm-developers] Web Services Javascript

[Christophe Humbert]

Anyone?

Christophe Humbert



On Sat, May 23, 2015 at 5:31 PM, Christophe Humbert <
chrissc.humbert at gmail.com> wrote:

> 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/20150528/3a085686/attachment.html>