[OpenLayers-Users] GetFeatureInfo problems

[Roald de Wit]

Hi Maria,

I vaguely remember having had this problem before and having solved it
quite easily. Just don't remember how (few years ago). Maybe you should
take this issue to the postgis mailing list and see if they can help.

If that doesn't help I can ask my former colleagues and see if they
know.

Kind regards, Roald

On Sun, 2008-01-20 at 12:52 -0800, Maria Panagou wrote:
> 
> I think I figured out the local problem, it's in this line of Mapserver log:
> 
> 
> msPOSTGISLayerGetShape: DECLARE mycursor2 BINARY CURSOR FOR SELECT
> "mag"::text,"depth"::text,asbinary(force_collection(force_2d(pos)),'NDR')
> from public.quake_small WHERE codee = 721 \r 
> 
> codee is the primary key in table quakes and it is a string. However
> mapserver treats it like a number, so correct query should have been
> 
> msPOSTGISLayerGetShape: DECLARE mycursor2 BINARY CURSOR FOR SELECT
> "mag"::text,"depth"::text,asbinary(force_collection(force_2d(pos)),'NDR')
> from public.quake_small WHERE codee = '0721' \r 
> 
> which returns results in Pgadmin query tool.
> 
> But now what? should i change the data type of this field?
-- 
Roald de Wit
Software Engineer
roald.dewit at lisasoft.com

Commercial Support for Open Source GIS Software
http://lisasoft.com/LISAsoft/SupportedProducts/