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 [EMAIL PROTECTED] Commercial Support for Open Source GIS Software http://lisasoft.com/LISAsoft/SupportedProducts/ _______________________________________________ Users mailing list [email protected] http://openlayers.org/mailman/listinfo/users
