<div dir="ltr">You are welcome :)</div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Nov 28, 2014 at 10:28 AM, Geoff Roberts <span dir="ltr"><<a href="mailto:geoff@strategicict.com.au" target="_blank">geoff@strategicict.com.au</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
Hi Uma,<br>
<br>
Thanks for the script - it was a great help.<br>
<br>
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.<br>
<br>
Using your script made it easier to find this.<br>
<br>
Kind regards,<br>
<br>
Geoff<div><div class="h5"><br>
<br>
<div>On 25/11/14 23:57, Uma S wrote:<br>
</div>
</div></div><blockquote type="cite"><div><div class="h5">
<div dir="ltr">Hi,
<div><br>
</div>
<div>Sorry, we are not able to reproduce this issue.</div>
<div><br>
</div>
<div>This works fine with attached script. Its lists all records
which matches the criteria.</div>
<div><br>
</div>
<div>Please do once again check in your instance. Do you records
which matches this condition in contacts module.</div>
<div><br>
</div>
<div><br>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Tue, Nov 25, 2014 at 5:44 PM,
Lajeesh <span dir="ltr"><<a href="mailto:lajeeshk@gmail.com" target="_blank">lajeeshk@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<div>
<div style="font-family:Calibri,sans-serif;font-size:11pt">A
small doubt. Is it due to the missing % symbol
before and after the search keyword..?</div>
</div>
<div dir="ltr">
<hr><span style="font-family:Calibri,sans-serif;font-size:11pt;font-weight:bold">From:
</span><span style="font-family:Calibri,sans-serif;font-size:11pt"><a href="mailto:geoff@strategicict.com.au" target="_blank">geoff</a></span><br>
<span style="font-family:Calibri,sans-serif;font-size:11pt;font-weight:bold">Sent:
</span><span style="font-family:Calibri,sans-serif;font-size:11pt">25-11-2014
05:17 PM</span><br>
<span style="font-family:Calibri,sans-serif;font-size:11pt;font-weight:bold">To:
</span><span style="font-family:Calibri,sans-serif;font-size:11pt"><a href="mailto:vtigercrm-developers@lists.vtigercrm.com" target="_blank">vtigercrm-developers@lists.vtigercrm.com</a></span><br>
<span style="font-family:Calibri,sans-serif;font-size:11pt;font-weight:bold">Subject:
</span><span style="font-family:Calibri,sans-serif;font-size:11pt">Re:
[Vtigercrm-developers] Odd Mobile and Web Service
problem withContacts</span><br>
<br>
</div>
<div>
<div>Hi,<br>
<br>
As a little follow-up. If I run a query such as:<br>
<br>
"select * from Contacts;"<br>
<br>
I get multiple results.<br>
<br>
As soon as I add a where clause such as:<br>
<br>
"select * from Contacts where firstname like
'chris';"<br>
<br>
I only get a single result even though running the
query against the<br>
database returns multiple results.<br>
<br>
The database query shown in the previous email is
being called from:<br>
include/Webservices/VtigerModuleOperation.php<br>
<br>
in the function: "public function query" - this then
calls<br>
$result = $this->pearDB->pquery($mysql_query,
array());<br>
<br>
Any thoughts/suggestions as to why the query fails
to return multiple<br>
records as soon as the where clause is added?<br>
<br>
Thanks,<br>
<br>
Geoff<br>
<br>
<br>
<br>
--<br>
View this message in context: <a href="http://vtiger-crm.2324883.n4.nabble.com/Vtigercrm-developers-Odd-Mobile-and-Web-Service-problem-with-Contacts-tp14545p14554.html" target="_blank">http://vtiger-crm.2324883.n4.nabble.com/Vtigercrm-developers-Odd-Mobile-and-Web-Service-problem-with-Contacts-tp14545p14554.html</a><br>
Sent from the vtigercrm-developers mailing list
archive at Nabble.com.<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
</div>
</div>
</div>
<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<div>
<div dir="ltr">With<br>
Best Regards<br>
Uma.S<br>
<div>Vtiger Team</div>
</div>
</div>
</div>
</div>
<br>
<fieldset></fieldset>
<br>
</div></div><pre>_______________________________________________
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a></pre><span class="HOEnZb"><font color="#888888">
</font></span></blockquote><span class="HOEnZb"><font color="#888888">
<br>
<pre cols="72">--
___________________________________
>From the desk of Geoff Roberts
Strategic I.C.T. Pty Ltd
email: <a href="mailto:geoff@strategicict.com.au" target="_blank">geoff@strategicict.com.au</a>
Mobile: 0416 210 111
<a href="http://www.strategicict.com.au" target="_blank">www.strategicict.com.au</a></pre>
</font></span></div>
<br>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr">With<br>Best Regards<br>Uma.S<br><div>Vtiger Team</div></div></div>
</div>