[Mapserver-users] DATA

Tue Jan 28 11:04:08 PST 2003

This is a multi-part message in MIME format.

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

Hi!
I have a problem with the DATA field. This SELECT work fine in PSQL:

SELECT ejes.the_geom AS the_geom, ejes.oid AS oid, ejes.mslink AS mslink =
FROM ejes_nodos LEFT JOIN ejes ON ejes_nodos.mslink =3D ejes.mslink

This retrieve 385 rows (with a geometry field).

But this, in a MAP file, produce a blank map:

  DATA "the_geom from (SELECT ejes.the_geom AS the_geom, ejes.oid AS =
oid, ejes.mslink AS mslink FROM ejes_nodos LEFT JOIN ejes ON =
ejes_nodos.mslink =3D ejes.mslink) as newable using unique oid using =
srid=3D'-1'"

Wath happens? Thanks!
Jos=E9 Mar=EDa Michia

------=_NextPart_000_0012_01C2C6E6.E38EF5D0
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 5.50.4522.1800" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi!</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I have a problem with the DATA field. =
This SELECT=20
work fine in PSQL:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>SELECT ejes.the_geom AS the_geom, =
ejes.oid AS oid,=20
ejes.mslink AS mslink FROM ejes_nodos LEFT JOIN ejes ON =
ejes_nodos.mslink =3D=20
ejes.mslink</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>This retrieve 385 rows (with a =
geometry=20
field).</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>But this, in a MAP file, produce a =
blank=20
map:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>  DATA "the_geom from (SELECT =
ejes.the_geom AS=20
the_geom, ejes.oid AS oid, ejes.mslink AS mslink FROM ejes_nodos LEFT =
JOIN ejes=20
ON ejes_nodos.mslink =3D ejes.mslink) as newable using unique oid using=20
srid=3D'-1'"<BR></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Wath happens? Thanks!</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Jos=E9 Mar=EDa =
Michia</DIV></FONT></BODY></HTML>

------=_NextPart_000_0012_01C2C6E6.E38EF5D0--