Pass information from CGI through Map file to OVF file and do a SQL Where

Todd Birkenholtz toddbirkey at YAHOO.COM
Fri Jan 14 16:03:01 EST 2005


Is there any way to pass more information through the CGI URL ?

I want to be able to use that variable and pass it to my OVF file and do a SQL "Where"  to get that locations Longitude Latitude. Then I will place a symbol at that location.

http://localhost/mapserver.exe?map=c:\inetpub\wwwroot\maptest\wanmap.map&mode=map&layer=states&place=xmarksthespot


I think the OVF will look something like this....
<OGRVRTDataSource>
       <OGRVRTLayer name="MyPoints">
        <SrcDataSource>ODBC:user/user at things,stuff</SrcDataSource>

        <SrcSQL>SELECT lat,lon from secretplaces where thespot='???Information from CGI ???'</SrcSQL>
        <GeometryType>wkbPoint</GeometryType>
        <GeometryField encoding="PointFromColumns" x="lon" y="lat"/>
      </OGRVRTLayer>
  </OGRVRTDataSource>



 Thank you.




---------------------------------
Do you Yahoo!?
 Yahoo! Mail - Easier than ever with enhanced search. Learn more.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20050114/81adf7fe/attachment.html


More information about the mapserver-users mailing list