Hi, Sure, like this
CONNECTIONTYPE POSTGIS CONNECTION "host=localhost dbname=postgis user=www-data password=www-data port=5432" DATA "way from (select way,osm_id ,landuse, name from osm_polygon where landuse is not null) as foo using unique osm_id using srid=3857" Even better, this is documented http://mapserver.org/input/vector/postgis.html -Jukka Rahkonen- ________________________________ Ahmet Temiz wrote: hello Is there any way to insert a sql query into a connection string as: DATA 'PG: dbname=tr2 host=localhost ... I want to manipulate ms - layer changing data line using java mapscript . regards -- Ahmet Temiz Jeoloji Müh. Afet ve Acil Durum Yönetimi Başkanlığı Planlama ve Zarar Azaltma Dairesi Başkanlığı ________________________ Ahmet Temiz Geological Eng. Information Systems - GIS Group Disaster and Emergency Management of Presidency _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
