[mapserver-users] php Mapscript queryByAttributes

[Lime, Steve D (MNIT)]

Try:

  $qfield = 'gid';
  $qstring = "([gid] IN '1,2,3')";
  @$datQuery = $query_layer->queryByAttributes($qfield,$qstring,MS_MULTIPLE);

I'm guessing the layer in question is PostGIS? In older versions of MapServer the query string could be given in the native SQL language of underlying driver. In 7.0 there was some expression normalization work done where expressions and filters are given in MapServer expression syntax and then converted to native SQL. It's possible that you've hit an example where the translation isn't working as it should.

Steve

-----Original Message-----
From: mapserver-users [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Sven Schroeter
Sent: Wednesday, October 11, 2017 10:46 AM
To: mapserver-users at lists.osgeo.org
Subject: [mapserver-users] php Mapscript queryByAttributes

Hi,

Old Server: PHP 5.4.36 with MS 6.4.1 (MS4W)
New Server: PHP 5.6.31 with MS 7.0.6 (MS4W 3.2.2)

My Test Script:

$qfield = 'gid';
$qstring = "gid IN (1,2,3)";
@$datQuery = $query_layer->queryByAttributes($qfield,$qstring,MS_MULTIPLE);

Works fine on the old Server, on the new Server no result.

I have tried to change the query expression, i.e.:
$qstring = "('[gid]' in '1,2,3')";

No result on old server and new...

How can I get it run on MS7?



Thanks + greetings 
Sven 
 


**************************************
NETGIS GbR
Benediktinerstr. 32a
54292 Trier
Tel.: 0651-1704731
Fax: 0651-1704733
schroeter at netgis.de
www.netgis.de


_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users