<DIV>Thank you Frank.</DIV>
<DIV>I have tried the %variable% method to get the variable into the Map file but my OVF file is external to the MAP file.</DIV>
<DIV> </DIV>
<DIV>I can not get the variables into the OVF file</DIV>
<DIV> </DIV>
<DIV>Now if I only could get the OVF inline with the MAP file I think I could get it to work.</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Any time I uncomment the inline method I get an error. but when I use the external method it works.</DIV>
<DIV> </DIV>
<DIV>Any suggestions?</DIV>
<DIV> </DIV>
<DIV>Thanks again.</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>my map file is like this....</DIV>
<DIV> </DIV>
<DIV>###################################################<BR>#<BR># NodeID<BR>#NodeID<BR> <BR> LAYER<BR> NAME nodeid<BR> TYPE POINT<BR> CONNECTIONTYPE OGR<BR> CONNECTION "c:\inetpub\wwwroot\maptest\office.ovf "<BR> #CONNECTION'<OGRVRTDataSource><BR> # <OGRVRTLayer name="MyPoints"><BR> # <SrcDataSource>ODBC:xxx/xxxr@xxx,xxx</SrcDataSource> <BR> # <BR> # <SrcSQL>SELECT lat,lon from WANINFO where NodeID ='officeABC'</SrcSQL> </DIV>
<DIV> # <GeometryType>wkbPoint</GeometryType> <BR> # <GeometryField encoding="PointFromColumns" x="lon" y="lat"/> <BR> #</OGRVRTLayer><BR> #</OGRVRTDataSource>'<BR> <BR> DUMP TRUE # for WFS only<BR> DATA "MyPoints"<BR> STATUS on<BR> CLASS<BR> <BR> symbol "circle2"<BR> size 10<BR> color 0 0 0</DIV>
<DIV> END<BR>END<BR>###################################################</DIV>
<DIV>SYMBOL<BR> NAME "circle2"<BR> TYPE ellipse<BR> FILLED false<BR> POINTS<BR> 1 1<BR> END<BR>END<BR></DIV>
<DIV>my office.ovf file is like this.....</DIV>
<DIV><OGRVRTDataSource><BR> <OGRVRTLayer name="MyPoints"><BR> <SrcDataSource>ODBC:xxx/xx@xx,xx</SrcDataSource> <BR> <BR> <SrcSQL>SELECT lat,lon from WANINFO where NodeID ='officeABC'</SrcSQL> <BR> <GeometryType>wkbPoint</GeometryType> <BR> <GeometryField encoding="PointFromColumns" x="lon" y="lat"/> <BR> </OGRVRTLayer><BR> </OGRVRTDataSource></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><BR><B><I>Frank Warmerdam <fwarmerdam@gmail.com></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">On Fri, 14 Jan 2005 13:03:01 -0800, Todd Birkenholtz<BR><TODDBIRKEY@YAHOO.COM>wrote:<BR>> <BR>> <BR>> Is there any way to pass more information through the CGI URL ? <BR>> <BR>> I want to be able to use that variable and pass it to my OVF file and do a<BR>> SQL "Where" to get that locations Longitude Latitude. Then I will place a<BR>> symbol at that location. <BR>> <BR>> http://localhost/mapserver.exe?map=c:\inetpub\wwwroot\maptest\wanmap.map&mode=map&layer=states&place=xmarksthespot<BR>> <BR>> <BR>> I think the OVF will look something like this.... <BR>> <OGRVRTDATASOURCE><BR>> <OGRVRTLAYER name="MyPoints"><BR>> <SRCDATASOURCE>ODBC:user/user@things,stuff</SRCDATASOURCE> <BR>> <BR>> <SRCSQL>SELECT lat,lon from secretplaces where<BR>> thespot='???Information from CGI ???'</SRCSQL> <BR>>
<GEOMETRYTYPE>wkbPoint</GEOMETRYTYPE> <BR>> <GEOMETRYFIELD y="lat" x="lon" encoding="PointFromColumns" /><BR>> </OGRVRTLAYER><BR>> </OGRVRTDATASOURCE><BR><BR>Todd,<BR><BR>I would suggest you read over:<BR>http://mapserver.gis.umn.edu/doc44/mapfile-reference.html#variablesubstitution<BR><BR>I have never tried it myself, but I think it is what you want. Also, you will<BR>need to be quite careful about "escaping" stuff if you have odd values.<BR><BR>Best regards,<BR>-- <BR>---------------------------------------+--------------------------------------<BR>I set the clouds in motion - turn up | Frank Warmerdam, warmerdam@pobox.com<BR>light and sound - activate the windows | http://pobox.com/~warmerdam<BR>and watch the world go round - Rush | Geospatial Programmer for Rent<BR></BLOCKQUOTE><p>
<hr size=1>Do you Yahoo!?<br>
All your favorites on one personal page – <a href="http://my.yahoo.com">Try My Yahoo!</a>