[Mapbender-users] Slightly OT: PostGIS Layer in UMN Mapserver

[Jan Peters-Anders]

Hello list,
I asked this question already on the UMN list but did not get any reply, so far (Friday afternoon? ;-)), but maybe someone here has a solution for my 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?

Also here on the mapbender list: Any suggestions will be greatly appreciated :-)

Greetings from Vienna

Jan
-- 










.

GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail