<html><head></head><body><div style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div><div>Sven,<br></div><div><br></div><div>Doing some tests, queryByAttributes does not accept LIKE nor IN, just single values or simple operators (I am using PostGIS).<br></div><div><br></div><div><font face=""courier new", courier, monaco, monospace, sans-serif">queryByAttributes("gid", "gid > 100", MS_MULTIPLE) // does not found anything</font></div><div><div><font face=""courier new", courier, monaco, monospace, sans-serif">queryByAttributes("gid", "100", MS_MULTIPLE) // found one result</font></div><div><font face=""courier new", courier, monaco, monospace, sans-serif">queryByAttributes("municipio", "'GUADALAJARA'", MS_MULTIPLE) // found one result</font></div><div><div><font face=""courier new", courier, monaco, monospace, sans-serif">queryByAttributes("municipio", "municipio LIKE 'G%'", MS_MULTIPLE) // does not found anything</font></div><div><font face=""courier new", courier, monaco, monospace, sans-serif"><font face=""courier new", courier, monaco, monospace, sans-serif">queryByAttributes("gid", "([gid] IN (100, 101))", MS_MULTIPLE); // query error<br></font></font><div><font face=""courier new", courier, monaco, monospace, sans-serif">queryByAttributes("municipio", "([municipio] LIKE 'G%')", MS_MULTIPLE); // query error</font></div><div><font face=""courier new", courier, monaco, monospace, sans-serif">queryByAttributes("gid", "([gid] > 100)", MS_MULTIPLE); // found 25 results</font><br></div></div><div><div><br></div><div>MS4W version is 3.1.3<br></div></div><div><br></div><div> Try to solve it by using FILTER, which allows more complex expressions:<br></div><div><br></div><div><font face=""courier new", courier, monaco, monospace, sans-serif">$layer->setFilter("gid IN (100, 101)");</font></div><div><br></div><div><br></div><div>Cheers<br></div><br></div></div></div><div id="ydpf5a14bdeyahoo_quoted_8561000593" class="ydpf5a14bdeyahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Wednesday, October 11, 2017, 10:55:17 AM CDT, Sven Schroeter <schroeter@netgis.de> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div dir="ltr">Hi,<br></div><div dir="ltr"><br></div><div dir="ltr">Old Server: PHP 5.4.36 with MS 6.4.1 (MS4W)<br></div><div dir="ltr">New Server: PHP 5.6.31 with MS 7.0.6 (MS4W 3.2.2)<br></div><div dir="ltr"><br></div><div dir="ltr">My Test Script:<br></div><div dir="ltr"><br></div><div dir="ltr">$qfield = 'gid';<br></div><div dir="ltr">$qstring = "gid IN (1,2,3)";<br></div><div dir="ltr">@$datQuery = $query_layer->queryByAttributes($qfield,$qstring,MS_MULTIPLE);<br></div><div dir="ltr"><br></div><div dir="ltr">Works fine on the old Server, on the new Server no result.<br></div><div dir="ltr"><br></div><div dir="ltr">I have tried to change the query expression, i.e.:<br></div><div dir="ltr">$qstring = "('[gid]' in '1,2,3')";<br></div><div dir="ltr"><br></div><div dir="ltr">No result on old server and new...<br></div><div dir="ltr"><br></div><div dir="ltr">How can I get it run on MS7?<br></div><div dir="ltr"><br></div><div dir="ltr"><br></div><div dir="ltr"><br></div><div dir="ltr">Thanks + greetings <br></div><div dir="ltr">Sven <br></div><div dir="ltr"> <br></div><div dir="ltr"><br></div><div dir="ltr"><br></div><div dir="ltr">**************************************<br></div><div dir="ltr">NETGIS GbR<br></div><div dir="ltr">Benediktinerstr. 32a<br></div><div dir="ltr">54292 Trier<br></div><div dir="ltr">Tel.: 0651-1704731<br></div><div dir="ltr">Fax: 0651-1704733<br></div><div dir="ltr"><a href="mailto:schroeter@netgis.de" rel="nofollow" target="_blank">schroeter@netgis.de</a><br></div><div dir="ltr">www.netgis.de<br></div><div dir="ltr"><br></div><div dir="ltr"><br></div><div dir="ltr">_______________________________________________<br></div><div dir="ltr">mapserver-users mailing list<br></div><div dir="ltr"><a href="mailto:mapserver-users@lists.osgeo.org" rel="nofollow" target="_blank">mapserver-users@lists.osgeo.org</a><br></div><div dir="ltr"><a href="https://lists.osgeo.org/mailman/listinfo/mapserver-users" rel="nofollow" target="_blank">https://lists.osgeo.org/mailman/listinfo/mapserver-users</a></div></div>
</div>
</div></div></body></html>