[Mapserver-users] sub-select

[nida Khan]

hmmmmm... strange

its seems really odd, it works other way round for me.
when I do
the_geom from westminster using unique oid using SRID=-1
it does NOT work

but this one does
the_geom from westminster using unique oid using srid=-1

And when I add
the_geom from (select oid,the_geom from westminster) as foo using unique oid
using srid=-1

it does not display that layer!!!

Can you also explain me or point me to a right document which explain the
logic of using "srid"??

I'm kinda stuck at this point :(.

Thank you very much for your response!
Regards
Nida.

----- Original Message -----
From: "Jan Hartmann" <jhart at frw.uva.nl>
To: <mapserver-users at lists.gis.umn.edu>
Sent: Friday, December 20, 2002 12:55 PM
Subject: Re: [Mapserver-users] sub-select


> Nida,
>
> You have to put SRID in capitals!. This is a small but very annoying bug
> that has been reported before
>
(http://postgis.refractions.net/pipermail/postgis-users/2002-November/001757
.html)
> but has not been resolved yet.
>
> Jan Hartmann
>
> nida Khan wrote:
> > Hi Everyone,
> >
> > I want to do a subselect from my .map file. I went through some
> > list-archive from that I tried these statements.
> >
> > DATA "the_geom from westminster"  works fine
> > DATA "the_geom from westminster using unique oid using srid=-1"    works
> > fine
> > DATA "the_geom from (select oid,the_geom from westminster) as foo using
> > unique oid using srid=-1"  no result
> >
> > I've got two tables, one with geom, other with features... I want to
> > display the certain feature as label on the map.
> >
> > What I'm missing in the above sql? Am I doing anything wrong? Is there
> > anything on database level that I have to change?
> >
> > Will Appreciate any inputs
> > Regards
> > Nida.
> >
>
> Jan Hartmann
> Department of Geography
> University of Amsterdam
> jhart at frw.uva.nl
>
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users