[postgis-users] Query error executing postgis declare.

[Jason M. Nielsen]

Anyone know what I might have setup wrong here? The select statement in psql
works fine. I cant determine if whatever issue I have is on the mapserver or
postgis side.

 msDrawMap(): Image handling error. Failed to draw layer named 'Utah
 Geological
 Study'.
 prep_DB(): Query error. Error executing POSTGIS DECLARE (the actual query)
 statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
 asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from s81
 WHERE
 the_geom && setSRID('BOX3D(1781048.9509602 472006.998403,2143367.3005688
 833751.562963)'::BOX3D, find_srid('','s81','the_geom') )'

 Postgresql reports the error ''

 More Help:

 Error with POSTGIS data variable. You specified '<check your .map file>'.
 Standard ways of specifiying are :
 (1) 'geometry_column from geometry_table'
 (2) 'geometry_column from (<sub query>) as foo using unique <column name>
 using
 SRID=<srid#>'

 Make sure you put in the 'using unique <column name>' and 'using SRID=#'
 clauses in.

 For more help, please see http://postgis.refractions.net/documentation.php

 Mappostgis.c - version of June 12/2003.

[root at vad3rZIM root]# postgres -V
postgres (PostgreSQL) 7.3.4

postgis-0.8.0

[root at vad3rZIM postgis]# /var/www/cgi-bin/mapserv -v
MapServer version 4.0.1 OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP SUPPORTS=PROJ
SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER
SUPPORTS=WFS_CLIENT INPUT=TIFF INPUT=EPPL7 INPUT=JPEG INPUT=POSTGIS INPUT=OGR
INPUT=GDAL INPUT=SHAPEFILE
[

Thanks,
Jason Nielsen

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/