[mapserver-users] sql clause in DATA

[Rahkonen Jukka]

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