Re: [mapserver-users] queryByAttributes syntax
Thanks, but that's exactly the kind of thing I'd like to prevent...
On 1/24/10, Worth Lutz w...@mindspring.com wrote:
I use the layer.connectiontype to adjust my query calls.
Connection Types
MS_INLINE, MS_SHAPEFILE, MS_TILED_SHAPEFILE, MS_SDE, MS_OGR, MS_TILED_OGR,
MS_POSTGIS, MS_WMS, MS_ORACLESPATIAL, MS_WFS, MS_GRATICULE, MS_MYGIS,
MS_RASTER, MS_PLUGIN
For example:
If layer.connectiontype == MS_SHAPEFILE) {
layer.queryByAttributes(map, myfield, searchValue,
mapscript.MS_MULTIPLE);
} else {
layer.queryByAttributes(map, null, myfield='searchValue',
mapscript.MS_MULTIPLE);
}
_
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Berend
Veldkamp
Sent: Friday, January 22, 2010 7:22 AM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] queryByAttributes syntax
Hi,
Where can I find more information about the queryByAttributes() function? I
found http://mapserver.org/mapscript/php/index.html#layerobj-class , but it
is not very detailed. By trial and error I found that for a PostGIS layer,
I
should use this syntax:
layer.queryByAttributes(map, null, myfield='searchValue',
mapscript.MS_MULTIPLE);
but for shapefiles, it seems it should be:
layer.queryByAttributes(map, myfield, searchValue,
mapscript.MS_MULTIPLE);
I am trying to write some generic code, but that's hard if there is no
single way to call this method. Also, I haven't found a way yet to do a
partial match on a shapefile (PostGIS supports 'LIKE')
Regards,
Berend Veldkamp
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.730 / Virus Database: 271.1.1/2640 - Release Date: 01/23/10
02:33:00
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] queryByAttributes syntax
Thanks, I'll try this. Berend On 1/22/10, Lime, Steve D (DNR) steve.l...@state.mn.us wrote: There's a single way to call the method, it's that you don't always have to supply the query item. The method signature is queryByAttributes (map (mapObj, qitem (string), qstring (string), mode (int)); The qstring is given in a format compatible with the underlying driver. For the database drivers it's basically a where-clause. For others you use MapServer expression syntax. Some expression types (e.g. string matches or regex) require the qitem. To do a partial match you could use a regex, for example: layer.queryByAttributes(map, myfield, /myregex/, mapscript.MS_MULTIPLE); Steve From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Berend Veldkamp Sent: Friday, January 22, 2010 6:22 AM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] queryByAttributes syntax Hi, Where can I find more information about the queryByAttributes() function? I found http://mapserver.org/mapscript/php/index.html#layerobj-class , but it is not very detailed. By trial and error I found that for a PostGIS layer, I should use this syntax: layer.queryByAttributes(map, null, myfield='searchValue', mapscript.MS_MULTIPLE); but for shapefiles, it seems it should be: layer.queryByAttributes(map, myfield, searchValue, mapscript.MS_MULTIPLE); I am trying to write some generic code, but that's hard if there is no single way to call this method. Also, I haven't found a way yet to do a partial match on a shapefile (PostGIS supports 'LIKE') Regards, Berend Veldkamp ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] queryByAttributes syntax
I use the layer.connectiontype to adjust my query calls.
Connection Types
MS_INLINE, MS_SHAPEFILE, MS_TILED_SHAPEFILE, MS_SDE, MS_OGR, MS_TILED_OGR,
MS_POSTGIS, MS_WMS, MS_ORACLESPATIAL, MS_WFS, MS_GRATICULE, MS_MYGIS,
MS_RASTER, MS_PLUGIN
For example:
If layer.connectiontype == MS_SHAPEFILE) {
layer.queryByAttributes(map, myfield, searchValue,
mapscript.MS_MULTIPLE);
} else {
layer.queryByAttributes(map, null, myfield='searchValue',
mapscript.MS_MULTIPLE);
}
_
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Berend
Veldkamp
Sent: Friday, January 22, 2010 7:22 AM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] queryByAttributes syntax
Hi,
Where can I find more information about the queryByAttributes() function? I
found http://mapserver.org/mapscript/php/index.html#layerobj-class , but it
is not very detailed. By trial and error I found that for a PostGIS layer, I
should use this syntax:
layer.queryByAttributes(map, null, myfield='searchValue',
mapscript.MS_MULTIPLE);
but for shapefiles, it seems it should be:
layer.queryByAttributes(map, myfield, searchValue,
mapscript.MS_MULTIPLE);
I am trying to write some generic code, but that's hard if there is no
single way to call this method. Also, I haven't found a way yet to do a
partial match on a shapefile (PostGIS supports 'LIKE')
Regards,
Berend Veldkamp
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.730 / Virus Database: 271.1.1/2640 - Release Date: 01/23/10
02:33:00
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] queryByAttributes syntax
There's a single way to call the method, it's that you don't always have to supply the query item. The method signature is queryByAttributes (map (mapObj, qitem (string), qstring (string), mode (int)); The qstring is given in a format compatible with the underlying driver. For the database drivers it's basically a where-clause. For others you use MapServer expression syntax. Some expression types (e.g. string matches or regex) require the qitem. To do a partial match you could use a regex, for example: layer.queryByAttributes(map, myfield, /myregex/, mapscript.MS_MULTIPLE); Steve From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Berend Veldkamp Sent: Friday, January 22, 2010 6:22 AM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] queryByAttributes syntax Hi, Where can I find more information about the queryByAttributes() function? I found http://mapserver.org/mapscript/php/index.html#layerobj-class , but it is not very detailed. By trial and error I found that for a PostGIS layer, I should use this syntax: layer.queryByAttributes(map, null, myfield='searchValue', mapscript.MS_MULTIPLE); but for shapefiles, it seems it should be: layer.queryByAttributes(map, myfield, searchValue, mapscript.MS_MULTIPLE); I am trying to write some generic code, but that's hard if there is no single way to call this method. Also, I haven't found a way yet to do a partial match on a shapefile (PostGIS supports 'LIKE') Regards, Berend Veldkamp ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
