<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body 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<br>
<br>
<div class="moz-cite-prefix">On 25/11/14 23:57, Uma S wrote:<br>
</div>
<blockquote
cite="mid:CAH83Uo+Wptt-P2NNg-zPxvwfOn1piT2qWNNONZHSL8OaZ1tVcQ@mail.gmail.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<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 moz-do-not-send="true"
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
moz-do-not-send="true"
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
moz-do-not-send="true"
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
moz-do-not-send="true"
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 moz-do-not-send="true"
href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
</div>
</div>
</div>
<br>
_______________________________________________<br>
<a moz-do-not-send="true" 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 class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
<a class="moz-txt-link-freetext" href="http://www.vtiger.com/">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
___________________________________
>From the desk of Geoff Roberts
Strategic I.C.T. Pty Ltd
email: <a class="moz-txt-link-abbreviated" href="mailto:geoff@strategicict.com.au">geoff@strategicict.com.au</a>
Mobile: 0416 210 111
<a class="moz-txt-link-abbreviated" href="http://www.strategicict.com.au">www.strategicict.com.au</a></pre>
</body>
</html>