<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body><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">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">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>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: http://vtiger-crm.2324883.n4.nabble.com/Vtigercrm-developers-Odd-Mobile-and-Web-Service-problem-with-Contacts-tp14545p14554.html<br>Sent from the vtigercrm-developers mailing list archive at Nabble.com.<br>_______________________________________________<br>http://www.vtiger.com/<br></body></html>