[Mapserver-users] sub-select

[Jan Hartmann]

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