<div>It´s not the case... I´m using Layers on URL and the output is in template.html...</div>
<div> </div>
<div>I executed the same test using POSTGIS connection, and It worked fine ,,, I got my template filled up as result...</div>
<div>Is there any difference using nquery with MSSQL2008 or maybe is a bug ?</div>
<div> </div>
<div>Thanks </div>
<div> </div>
<div>Paul<br><br></div>
<div class="gmail_quote">On Thu, Oct 29, 2009 at 11:06 AM, Bob Basques <span dir="ltr"><<a href="mailto:Bob.Basques@ci.stpaul.mn.us">Bob.Basques@ci.stpaul.mn.us</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div>
<p style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><font size="3" face="Comic Sans MS">I'm no expert on this one, but . . .</font> </p><br>
<p style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><font size="3" face="Comic Sans MS">If you do an NQUERY Mapserver needs to know which layer you plan on querying, either by name, explicitly through the call (layer=??) or by having the mapfile give them up by default (STATUS=default ??), either way, mapserver need to know somehow what to apply the query to, I think.</font> </p>
<br>
<p style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><font size="3" face="Comic Sans MS">Also, how do you want mapserver to output the results of the NQUERY? by templated output or . . . you can use NQUERYMAP I believe to get an image back of the NQUERY . . .</font> </p>
<br>
<p style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><font size="3" face="Comic Sans MS">bobb</font> </p>
<div>
<div></div>
<div class="h5"><br>
<p style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><br><br>>>> Paul james <<a href="mailto:pauljame@gmail.com" target="_blank">pauljame@gmail.com</a>> wrote:<br></p>
<div style="BORDER-LEFT: #050505 1px solid; BACKGROUND-COLOR: #f3f3f3; MARGIN: 0px 0px 0px 15px; PADDING-LEFT: 7px">
<div content="text/html; charset=ISO-8859-1" http-equiv="Content-Type">
<p style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px">Hello guys... </p></div>
<div>
<p style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px">I´m got this error when trying to execute a Nquery : </p></div>
<div>
<p style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><a href="http://localhost/cgi-bin-54/mapserv.exe?map=Map.map&mode=nquery&LAYERS=TEST&mapext=-58.358076171875+-11.42570625+-57.193525390625+-10.37101875&imgext=-58.358076171875+-11.42570625+-57.193525390625+-10.37101875&map_size=1221+762&imgxy=1221+762&imgbox=0+0+1221+762" target="_blank">http://localhost/cgi-bin-54/mapserv.exe?map=Map.map&mode=nquery&LAYERS=TEST&mapext=-58.358076171875+-11.42570625+-57.193525390625+-10.37101875&imgext=-58.358076171875+-11.42570625+-57.193525390625+-10.37101875&map_size=1221+762&imgxy=1221+762&imgbox=0+0+1221+762</a> </p>
</div>
<div><br></div>
<div>
<p style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px">msDrawMap(): Image handling error. Failed to draw layer named 'TEST'.<br><br>But, If I execute the same url with "mode=map", the image is generated fine... What this error means?<br>
</p></div>
<div><br></div>
<div>
<p style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px">TEST Layer </p></div>
<div><br></div>
<div>
<p style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px">LAYER<br>NAME TEST<br>GROUP "TE"<br>TYPE polygon<br>STATUS ON<br>CONNECTIONTYPE PLUGIN<br>PLUGIN "msplugin_mssql2008.dll"<br>CONNECTION "server=X;Integrated Security=false;database=X;uid=X;pwd=X"<br>
DATA "the_geom from viw USING UNIQUE oid USING SRID=0"<br>CLASS<br>TEMPLATE "template.html"<br>NAME "X"<br>STYLE<br>OUTLINECOLOR 150 150 150<br>WIDTH 1<br>END<br>END<br>END </p></div>
<div>
<p style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><br>Thanks<br><br>Paul </p></div></div></div></div></div></blockquote></div><br>