Found the problem (thanks to Nicol ;-)
Code:
@$myQuery = $layer->queryByAttributes('nr_','7', MS_SINGLE);
must be changed to:
@$myQuery = $layer->queryByAttributes('nr_','nr_=7', MS_SINGLE);
Is this a bug?
Sven
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, May 28, 2008 12:48 PM
Subject: [mapserver-users] queryByAttributes on PostGIS-Layer
Hallo list,
My test-system: Mapserver 5.02 on WinXP and postgreSQL 8.2
I try to make some querys via php-mapscript for a postgis-layer:
queryByPoint,queryByShape and queryByRect is no problem.
queryByAttributes always return "no result" (field 'nr_' is an integer)
If I use a shapefile for the same data (biogasanlagen.shp)
queryByAttributes works fine.
mapfile:
...
LAYER
NAME "biogasanlagen"
TYPE point
STATUS on
CONNECTIONTYPE postgis
CONNECTION "user=postgres password=xyz dbname=mydb host=localhost
port=5432"
DATA "the_geom from biogasanlagen using unique gid"
#DATA biogasanlagen.shp
TEMPLATE void
CLASS
Name "biogasanlagen"
OUTLINECOLOR 128 70 0
COLOR 230 70 0
SYMBOL 'circle'
SIZE 12
END # CLASS
TRANSPARENCY 88
TOLERANCE 8
END
...
php-Code:
...
$layer = $map->getLayerByName("biogasanlagen");
@$myQuery = $layer->queryByAttributes('nr_','7', MS_SINGLE);
...
any idea?
Thanks Sven
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
