[Mapserver-users] sub-select

[Jan Hartmann]

using SRID= ... using UNIQUE=.. are only necessary in subselects, so 
they are not needed in your first two data statements . A description 
for this has recently been added to the docs in

http://postgis.refractions.net/docs/x549.html#AEN607

What exactly does the third statement do? Does it return an error or 
just a blank map?

Jan Hartmann

nida Khan wrote:
> 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
> 
> 
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> 

Jan Hartmann
Department of Geography
University of Amsterdam
jhart at frw.uva.nl