Subject: Re: AW: RE: [mapserver-users] php Mapscript queryByAttributes
Sven,
This is a good workarround. It's weird why the IN operator is not working for
Postgres but as Steve wrote, a ticket will be opened.
On Thursday, October 12, 2017, 8:04:46 AM CDT, Sven Schroeter
<schroe...@netgis.d
sage-
From: Sven Schroeter [mailto:schroe...@netgis.de]
Sent: Thursday, October 12, 2017 8:05 AM
To: Lime, Steve D (MNIT) <steve.l...@state.mn.us>; 'Carlos Ruiz'
<boolean10...@yahoo.com>; mapserver-users@lists.osgeo.org
Subject: AW: RE: [mapserver-users] php Mapscript queryByA
on: Lime, Steve D (MNIT) [mailto:steve.l...@state.mn.us]
Gesendet: Mittwoch, 11. Oktober 2017 23:33
An: Carlos Ruiz; mapserver-users@lists.osgeo.org; Sven Schroeter
Betreff: RE: RE: [mapserver-users] php Mapscript queryByAttributes
Ugh, my bad. At least with the LIKE operator it’s because MapServer doe
2017 4:03 PM
To: mapserver-users@lists.osgeo.org; Sven Schroeter <schroe...@netgis.de>;
Lime, Steve D (MNIT) <steve.l...@state.mn.us>
Subject: Re: RE: [mapserver-users] php Mapscript queryByAttributes
Hey Steve,
> the IN operator works off a delimited list, try queryB
ens
in a list.
queryByAttributes("municipio", "([municipio] LIKE 'G%')", MS_MULTIPLE); //
query error
This is close, it’s a logical expression but you’re comparing a number against
a string. It should bequeryByAttributes("municipio", "(‘[municipio]’ LIKE
'G%'
age-
From: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] On
Behalf Of Sven Schroeter
Sent: Wednesday, October 11, 2017 10:46 AM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] php Mapscript queryByAttributes
Hi,
Old Server: PHP 5.4.36 with MS 6.4.1 (MS4W)
Ne
IKE 'G%')", MS_MULTIPLE); //
query error
This is close, it’s a logical expression but you’re comparing a number against
a string. It should be queryByAttributes("municipio", "(‘[municipio]’ LIKE
'G%')", MS_MULTIPLE);
Steve
From: mapserver-users [mailto:mapserver-users-bo
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.