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

[Jon Saints]

that Did the trick. Thanks so much. I was able to
determine that in my mapserver mapfile I had miss
spelled the name of my geometry column. 

I had "geom" instead of "the_geom"

Jon

--- Nicolas Ribot <nicky666 at gmail.com> wrote:

> 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
> >
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
>
http://postgis.refractions.net/mailman/listinfo/postgis-users
>