[mapserver-users] Help with NQuery error (CGI) using MSSQL2008

[Paul james]

It´s not the case... I´m using Layers on URL and the output is in
template.html...

I executed the same test using POSTGIS connection, and It worked fine ,,, I
got my template filled up as result...
Is there any difference using nquery with MSSQL2008 or maybe is a bug ?

Thanks

Paul

On Thu, Oct 29, 2009 at 11:06 AM, Bob Basques
<Bob.Basques at ci.stpaul.mn.us>wrote:

>  I'm no expert on this one, but . . .
>
> 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.
>
> 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 . . .
>
> bobb
>
>
>
> >>> Paul james <pauljame at gmail.com> wrote:
>
> Hello guys...
>
> I´m got this error when trying to execute a Nquery :
>
>
> 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
>
>  msDrawMap(): Image handling error. Failed to draw layer named 'TEST'.
>
> But, If I execute the same url with "mode=map", the image is generated
> fine... What this error means?
>
>  TEST Layer
>
>  LAYER
> NAME TEST
> GROUP "TE"
> TYPE polygon
> STATUS ON
> CONNECTIONTYPE PLUGIN
> PLUGIN "msplugin_mssql2008.dll"
> CONNECTION "server=X;Integrated Security=false;database=X;uid=X;pwd=X"
> DATA "the_geom from viw USING UNIQUE oid USING SRID=0"
> CLASS
> TEMPLATE "template.html"
> NAME "X"
> STYLE
> OUTLINECOLOR 150 150 150
> WIDTH 1
> END
> END
> END
>
>
> Thanks
>
> Paul
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20091029/c54f3cfd/attachment.htm>