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

[Uma S]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20141125/f0df77f2/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: testscript.php
Type: application/x-httpd-php
Size: 454 bytes
Desc: not available
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20141125/f0df77f2/attachment.php>