[postgis-users] prepare_database(): Query error. Error executing

[Nicolas Ribot]

Hi Joe

Did not encounter this exact error message before, but you should try
to execute the offending query in postgis:
SELECT  asbinary(force_collection(force_2d(geom)),'NDR'),gid::text
 from province2000_proj 
WHERE geom && setSRID('BOX3D(92.71

(by the way, the end of the query is missing).

If this query generates an error, it will be easier to fix.
When the query is working in postgis, adapt your mapfile to match the
modifications you made.

Nicolas

On 8/2/05, Jon Saints <saintsjd at yahoo.com> wrote:
> When attempting to connect to postgis from mapserver I
> get the error...
> 
> msDrawMap(): Image handling error. Failed to draw
> layer named 'province2000_proj'.
> prepare_database(): Query error. Error executing
> POSTGIS DECLARE (the actual query) statement: 'DECLARE
> mycursor BINARY CURSOR FOR SELECT
> asbinary(force_collection(force_2d(geom)),'NDR'),gid::text
> from province2000_proj WHERE geom &&
> setSRID('BOX3D(92.71
> 
> has anyone encountered this before?
> Thanks
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>