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

[Lajeesh]

A small doubt. Is it due to the missing % symbol before and after the search keyword..?

-----Original Message-----
From: "geoff" <geoff at strategicict.com.au>
Sent: ‎25-‎11-‎2014 05:17 PM
To: "vtigercrm-developers at lists.vtigercrm.com" <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/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20141125/74a04063/attachment.html>