[postgis-users] About Invalid OGC WKT Error

[strk at refractions.net]

On Wed, Feb 02, 2005 at 06:22:56PM -0500, Kralidis,Tom [Burlington] wrote:
> 
> Here's what shows up in my error logs when MapServer attempts to access
> when I have MapServer in debugging mode:

(cuts)

> query_string_0_6:DECLARE mycursor BINARY CURSOR FOR SELECT
> asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from
> service_endpoints WHERE the_geom && setSRID('BOX3D(-141.089
> 36.392987,-52.089 89.784987)'::BOX3D,
> find_srid('','service_endpoints','the_geom') )

(cuts)

> msPOSTGISLayerClose -- query_result is NULL


That query does not return any result. Check manually invoking it.
Also, check:

# SELECT extent(asbinary(force_collection(force_2d(the_geom)),'NDR'));
# SELECT setSRID('BOX3D(-141.089 36.392987,-52.089 89.784987)'::BOX3D,
  find_srid('','service_endpoints','the_geom') )

--strk;