<div dir="ltr">I don't think grouped where clauses are supported.<br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Apr 6, 2020 at 2:50 PM Alan Lord <<a href="mailto:alanslists@gmail.com">alanslists@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">I need to use vtws_query but when I include parenthesis like this I get <br>
an error:<br>
<br>
$query = "SELECT id, name, status, assigned_user_id<br>
FROM LSModule<br>
WHERE (status = 'Active' OR status = 'Development')<br>
AND tgt_module = '".$moduleName."';";<br>
<br>
<br>
<br>
> Mon Apr 6 09:08:59 2020,529 [28641] DEBUG VT - Syntax Error on line 1: token '(' Unexpected PARENOPEN((), expected one of: COLUMNNAME<br>
<br>
If I remove the parenthesis the query runs but I am not then sure if the <br>
result as actually what I want, e.g. how are the OR and AND clauses <br>
interpreted?<br>
<br>
Cheers<br>
<br>
Al<br>
<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br>
</blockquote></div>