[Mapserver-users] sub-select

Fri Dec 20 04:27:13 EST 2002

This is a multi-part message in MIME format.

------=_NextPart_000_006C_01C2A809.FB025000
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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=3D-1"    =
works fine
DATA "the_geom from (select oid,the_geom from westminster) as foo using =
unique oid using srid=3D-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.

------=_NextPart_000_006C_01C2A809.FB025000
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Hi Everyone,</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>I want to do a subselect from my .map file. I went =
through=20
some list-archive from that I tried these statements.</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>DATA "the_geom from westminster"&nbsp;&nbsp;<FONT=20
color=3D#0000ff>works fine</FONT></FONT></DIV>
<DIV><FONT size=3D2>DATA "the_geom from westminster using unique oid =
using=20
srid=3D-1"&nbsp;&nbsp;&nbsp; <FONT color=3D#0000ff>works =
fine</FONT></FONT></DIV>
<DIV><FONT size=3D2>DATA "the_geom from (select oid,the_geom from =
westminster) as=20
foo using unique oid using srid=3D-1"&nbsp; <FONT color=3D#0000ff>no=20
result</FONT></FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>I've got two tables, one with geom, other with =
features... I=20
want to display the certain feature as label on the map.</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>What I'm missing in the above sql? Am I doing =
anything wrong?=20
Is there anything on database level that I have to change?</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Will Appreciate any inputs</FONT></DIV>
<DIV><FONT size=3D2>Regards</FONT></DIV>
<DIV><FONT size=3D2>Nida.</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_006C_01C2A809.FB025000--