<div>Hi Rich:</div> <div> </div> <div>I have modified the map file as you told me:</div> <div> </div> <div>HEADER main.html</div> <div>TEMPLATE empty.html</div> <div>CLASS</div> <div> </div> <div>END</div> <div> </div> <div>When I try to display the query results I get only the main.html without any data inside, like I just want to display the html file. <BR></div> <div>The emty.html:</div> <div> </div> <div><html><head></head><body></body></html></div> <div> </div> <div>If I try to query from the map I get the same result: the main.html page without any data inside</div> <div> </div> <div>Where I do wrong?</div> <div> </div> <div>Thank you again</div> <div> </div> <div>William</div> <div><BR><B><I>Richard Greenwood <richard.greenwood@gmail.com></I></B> wrote:</div> <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px
solid">On 12/10/06, william paul <WILLIAMPAUL28@YAHOO.COM>wrote:<BR>> Hello:<BR>> I am using dBox, the example from<BR>> http://maps.dnr.state.mn.us/tools/dbox/example/example.html.<BR>> I have a database on Sql ServerExpress and I am using ASPX to query the<BR>> database and display the results<BR>> I want to map some of the results, but I don't know how to do it. I tried<BR>> with the example provided by Rich:<BR>><BR>> mapserv.exe?map=my.map<BR>> &mode=itemnquery<BR>> &qitem=pidn<BR>> &qlayer=join_region_spatial<BR>> &mapext=shapes<BR>> &savequery=true<BR>> &qstring=22-41-16-33-4-11-004<BR>><BR>> but instead of mapping the result I get a basic mapserver query results,<BR>> like they were queried from the map<BR>><BR>> How can I map the query results from a database with dbox.js and mapserv.js<BR>> on the example from<BR>>
http://maps.dnr.state.mn.us/tools/dbox/example/example.html?<BR>><BR>> Thank you in advance<BR>><BR>> William<BR><BR>You need to set a template for the queried layer to display the map.<BR>In other words, the template for your query layer has to be an html<BR>page with a map in it. You set this in the .map file.<BR><BR>The map file definition for the query string above is shown below. The<BR>HEADER just references my main html map page (it is not a special<BR>page). The TEMPLATE is an empty file. The reason for this is that if a<BR>query result returns more than one object you will get one map for<BR>each object if you reference the html map page with the TEMPLATE key<BR>word, but referencing it with the HEADER causes all queried objects to<BR>be drawn on one map, and zoomed to an extent including all of the<BR>objects.<BR><BR><BR>Layer<BR>NAME "join_region_spatial"<BR>STATUS OFF # either set to DEFAULT, or explicitly call for it<BR>TYPE polygon<BR>DATA
"ownership_region.shp"<BR>FILTERITEM Pidn<BR>Filter "%pidn%"<BR>HEADER "sc_map.html"<BR>TEMPLATE "empty2.html"<BR>CLASS<BR>OUTLINECOLOR 255 255 0<BR>SYMBOL 'solid' SIZE 6<BR>END # class<BR>END # layer<BR><BR><BR><BR>-- <BR>Richard Greenwood<BR>richard.greenwood@gmail.com<BR>www.greenwoodmap.com<BR></BLOCKQUOTE><BR><p>
<hr size=1>Everyone is raving about <a href="http://us.rd.yahoo.com/evt=45083/*http://advision.webevents.yahoo.com/mailbeta">the all-new Yahoo! Mail beta.</a>