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

[Steve Lime]

Probably. Does a point query work? I reassigned the ticket to the keeper
of the SQLServer
driver in hopes that it gets attention.

Curiously, have you tried 5.6 at all with SQLServer?

Steve

>>> On 10/30/2009 at 12:22 PM, in message
<33fad6880910301022s40c76f88ha011362964e21808 at mail.gmail.com>, Paul
james
<pauljame at gmail.com> wrote:
> I think so...
> Is it related with that ticket?
> http://trac.osgeo.org/mapserver/ticket/3058 
> 
> Paul
> 
> On Fri, Oct 30, 2009 at 1:53 PM, Steve Lime
<Steve.Lime at dnr.state.mn.us>wrote:
> 
>> Odd. Unfortunately I can't debug anything related to MSSQL2008,
perhaps
>> the driver isn't
>> supporting functions necessary to complete a query?
>>
>> Steve
>>
>> >>> On 10/30/2009 at 6:33 AM, in message
>> <33fad6880910300433i342c619am99935a607896643f at mail.gmail.com>, Paul
>>  james
>> <pauljame at gmail.com> wrote:
>> > Hey Steve...
>> >
>> > Yes I had...
>> > QUERYMAP
>> >  COLOR 255 0 0
>> >  SIZE -1 -1
>> >  STATUS ON
>> >  STYLE hilite
>> > END
>> >
>> > With Status OFF I got that :
>> > Content-type: text/html
>> >
>> > Using MSSQL2008
>> >
>> > Paul
>> >
>> >
>> > On Thu, Oct 29, 2009 at 6:13 PM, Steve Lime
>> <Steve.Lime at dnr.state.mn.us>wrote:
>> >
>> >> Do you have a querymap object configured with status on? I would
>> guess
>> >> so in order to see that
>> >> error. What happens if you set STATUS OFF in the querymap?
>> >>
>> >> >>> On 10/29/2009 at 7:57 AM, in message
>> >> <33fad6880910290557m71ee3fdatd470590e3256f175 at mail.gmail.com>,
Paul
>> >> james
>> >> <pauljame at gmail.com> wrote:
>> >>  > Hello guys...
>> >> > Ím got this error when trying to execute a Nquery :
>> >> >
>> >>
>> >>
>> >
>>
>> 
>
http://localhost/cgi-bin-54/mapserv.exe?map=Map.map&mode=nquery&LAYERS=TEST&mape

> 
>>
>> > x
>> >>
>> >> >
>> >>
>> >>
>> >
>>
>> 
>
t=-58.358076171875+-11.42570625+-57.193525390625+-10.37101875&imgext=-58.35807
> 
>> > 61718
>> >> >
>> >>
>> >>
>> >
>>
>> 
>
75+-11.42570625+-57.193525390625+-10.37101875&map_size=1221+762&imgxy=1221+762&i
> 
>> > mgb
>> >> > ox=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
>> >>
>>