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

[Geoff Roberts]

Hi Lajeesh,

On 25/11/14 23:14, Lajeesh wrote:
> A small doubt. Is it due to the missing % symbol before and after the 
> search keyword..?

Thanks for getting back.

Unfortunately no, I've tried it with '%chris%' as well - same result, 
only 1 record returned.

I've also tried adding order by to the end of the query - same result as 
well.

Kind regards,

Geoff

> ------------------------------------------------------------------------
> 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/