[Vtigercrm-developers] Odd Mobile and Web Service problem withContacts

[Uma S]

You are welcome :)

On Fri, Nov 28, 2014 at 10:28 AM, Geoff Roberts <geoff at strategicict.com.au>
wrote:

>  Hi Uma,
>
> Thanks for the script - it was a great help.
>
> In the end I must have damaged a couple of records whilst testing - the
> pattern on a number of different tests I was doing just happened to return
> the single result.
>
> Using your script made it easier to find this.
>
> Kind regards,
>
> Geoff
>
>
> On 25/11/14 23:57, Uma S wrote:
>
> Hi,
>
>  Sorry, we are not able to reproduce this issue.
>
>  This works fine with attached script. Its lists all records which
> matches the criteria.
>
>  Please do once again check in your instance. Do you records which
> matches this condition in contacts module.
>
>
>
> On Tue, Nov 25, 2014 at 5:44 PM, Lajeesh <lajeeshk at gmail.com> wrote:
>
>>  A small doubt. Is it due to the missing % symbol before and after the
>> search keyword..?
>>  ------------------------------
>> From: geoff <geoff at strategicict.com.au>
>> Sent: ‎25-‎11-‎2014 05:17 PM
>> To: vtigercrm-developers at lists.vtigercrm.com
>> Subject: Re: [Vtigercrm-developers] Odd Mobile and Web Service problem
>> withContacts
>>
>>  Hi,
>>
>> As a little follow-up. If I run a query such as:
>>
>> "select * from Contacts;"
>>
>> I get multiple results.
>>
>> As soon as I add a where clause such as:
>>
>> "select * from Contacts where firstname like 'chris';"
>>
>> I only get a single result even though running the query against the
>> database returns multiple results.
>>
>> The database query shown in the previous email is being called from:
>> include/Webservices/VtigerModuleOperation.php
>>
>> in the function: "public function query" - this then calls
>> $result = $this->pearDB->pquery($mysql_query, array());
>>
>> Any thoughts/suggestions as to why the query fails to return multiple
>> records as soon as the where clause is added?
>>
>> Thanks,
>>
>> Geoff
>>
>>
>>
>> --
>> View this message in context:
>> http://vtiger-crm.2324883.n4.nabble.com/Vtigercrm-developers-Odd-Mobile-and-Web-Service-problem-with-Contacts-tp14545p14554.html
>> Sent from the vtigercrm-developers mailing list archive at Nabble.com.
>> _______________________________________________
>> http://www.vtiger.com/
>>
>> _______________________________________________
>> http://www.vtiger.com/
>>
>
>
>
>  --
>  With
> Best Regards
> Uma.S
> Vtiger Team
>
>
> _______________________________________________http://www.vtiger.com/
>
>
> --
> ___________________________________
> From the desk of Geoff Roberts
> Strategic I.C.T. Pty Ltd
>
> email: geoff at strategicict.com.au
> Mobile: 0416 210 111
> www.strategicict.com.au
>
>
> _______________________________________________
> http://www.vtiger.com/
>



-- 
With
Best Regards
Uma.S
Vtiger Team
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20141128/ee1aaba6/attachment-0001.html>