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

[Geoff Roberts]

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 
> <mailto:lajeeshk at gmail.com>> wrote:
>
>     A small doubt. Is it due to the missing % symbol before and after
>     the search keyword..?
>     ------------------------------------------------------------------------
>     From: geoff <mailto:geoff at strategicict.com.au>
>     Sent: ‎25-‎11-‎2014 05:17 PM
>     To: vtigercrm-developers at lists.vtigercrm.com
>     <mailto: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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20141128/9d6ec5d6/attachment.html>