[postgis-users] Problem displaying postgis data with maapserver

[Shaq Gbadebo]

Hi!

I have sorted out an initial problem, which was my postgresql server was not 
not set for tcp/ip connections. But now here is the error I am getting.

msDrawMap(): Image handling error. Failed to draw layer named 'test'.
prep_DB(): Query error. Error executing POSTGIS DECLARE (the actual query) 
statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT 
asbinary(force_collection(force_2d()),'NDR'),OID::text from HBHB WHERE 
&& setSRID('BOX3D(-1333332 -999999,1333332 999999)'::BOX3D, 
find_srid('','HBHB','') )'

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.
msPOSTGISLayerParseData(): Query error. Error parsing POSTGIS data variable. 
Must contain 'geometry_column from table_name' or 'geom from (subselect) as 
foo' (couldnt find ' from '). More help:

Error with POSTGIS data variable. You specified 'geom FROM test'.
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.

Any sort of help would be appreciated.

Thanks

Shaq.