Hello all,
I´m tring to use mapserver variable substitution (
http://mapserver.gis.umn.edu/docs/reference/mapfile/variable_sub) and it
works using cgi mapserv but I can't figure out how to use in pmapper.
Is it possible to pass variables to map file in the url using pmapper?
For example: I want to pass the variable "newpoint" in the url and use it in
the query string in mysql
MAP FILE:
LAYER
NAME testpoint
TYPE POINT
STATUS DEFAULT
CONNECTIONTYPE OGR
CONNECTION "
<OGRVRTDataSource>
<OGRVRTLayer name='mydata'>
<SrcDataSource>MYSQL:dbname,user=xxxx,password=xxxx,host=localhost,port=3306,tables=position</SrcDataSource>
<SrcSQL>
select point, lat, lon from position where
point='%newpoint%';
</SrcSQL>
<GeometryType>wkbPoint</GeometryType>
<GeometryField encoding='PointFromColumns' x='lon' y='lat'/>
</OGRVRTLayer>
</OGRVRTDataSource>"
DATA "mydata"
LABELITEM "point"
...
END # Layer
Using cgi mapserv:
http://localhost/cgi-bin/mapserv.exe?map=mymap.map&mode=map&newpoint=point-test1
Using pmapper:
http://localhost/pmapper_test/map.phtml?&newpoint=point-test1
In pmapper I dont have any error in the logs, the map is drawn (other
layers) but the point is not showed.
If I put a fixed value in the query string, instead of using variables , it
works ok:
<SrcSQL>
select point, lat, lon from position where
point='point-test1';
</SrcSQL>
Thanks
Leandro
------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
