Mapfile creation including PostGIS layer with changing table (view) name?

[Jan Peters-Anders]

Hello list,

I have a question concerning the following problem:

I have a webapplication that creates (via an SQL query) a view in my PostGres database. Then I display this view via mapserver. Mapfile code looks as follows:

-----8<-----------------------
LAYER
   NAME firmen_psql
   TYPE POINT
   STATUS ON
   CONNECTION "user=blabla password=bla dbname=foo host=localhost port=5432"
   CONNECTIONTYPE postgis
   DATA "the_geom from v_iis_over"
-----8<-----------------------

That works perfectly. Now I want to have multiple users query the database, creating views according to e.g. a session id, e.g:

"v_iis_over_[sessionId]"

Now my problem is, that I would need different mapfiles containing the different table (view) names to accomplish a correct display of the query results for each user. Is it e.g. possible to hand over the new (view) id via an http request? Or do I have to create a new mapfile each time a new session is created?

Any suggestions are greatly appreciated.

Thank you very much in advance again

Jan Peters-Anders


-- 








.

Ist Ihr Browser Vista-kompatibel? Jetzt die neuesten 
Browser-Versionen downloaden: http://www.gmx.net/de/go/browser