[Mapserver-users] joins not working in version 4.0?

Fri Oct 24 17:31:43 EDT 2003

This is a multi-part message in MIME format.

------=_NextPart_000_000A_01C39A4C.4F6E8160
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I am joining a layer with a DBF on the field "ID", and am seeing this as =
a result of a query:

a.. Record 3663 (34): [[IDDBF]]
a.. Record 3663 (34): [[IDDBF]]

where IDDBF is the ID column in the DBF file. You can see from the query =
template below that the ID and RGE fields from the shapefile are coming =
across correctly, while the data from the DBF field is not appearing:

----- join.html -----
<li> Record [ID] ([RGE]): [IDDBF]<br>

According to =
http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?MigrationGuide, this =
release was to have restored one-to-many processing.

My join template contains just the single line: [join_twps], where =
'twps' is the NAME of the join.

Has anyone worked this out yet?

Also, if the fields in the layer and the DBF are named the same, how do =
you differentiate the layer from the DBF field? Perhaps I am missing a =
part of the syntax that points to the correct data...

Thanks,
Chris

------=_NextPart_000_000A_01C39A4C.4F6E8160
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.2733.1800" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3D"Courier New" size=3D2>I am joining a layer with a DBF =
on the=20
field "ID", and am seeing this as a result of a query:</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2></FONT>&nbsp;</DIV>
<DIV>
<LI><FONT face=3D"Courier New" size=3D2>Record 3663 (34): =
[[IDDBF]]</FONT>
<LI><FONT face=3D"Courier New" size=3D2>Record 3663 (34):=20
[[IDDBF]]</FONT></LI></DIV>
<DIV><FONT face=3D"Courier New" size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3D"Courier New" size=3D2>where IDDBF is the ID column in =
the DBF=20
file. You can see from the query template below that the ID and RGE =
fields from=20
the shapefile are coming across correctly, while the data from the DBF =
field is=20
not appearing:</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3D"Courier New" size=3D2>----- join.html =
-----</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2>&lt;li&gt; Record [ID] ([RGE]): =

[IDDBF]&lt;br&gt;</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3D"Courier New" size=3D2>According to </FONT><A=20
href=3D"http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?MigrationGuide"><FON=
T=20
face=3D"Courier New"=20
size=3D2>http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?MigrationGuide</FON=
T></A><FONT=20
face=3D"Courier New" size=3D2>, this release was to have restored =
one-to-many=20
processing.</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3D"Courier New" size=3D2>My join template contains just =
the single=20
line: [join_twps], where 'twps' is the NAME of the join.</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3D"Courier New" size=3D2>Has anyone worked this out=20
yet?</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3D"Courier New" size=3D2>Also, if the fields in the =
layer and the=20
DBF are named the same, how do you differentiate the layer from the DBF =
field?=20
Perhaps I am missing a part of the syntax that points to the correct=20
data...</FONT></DIV>
<DIV><FONT face=3D"Courier New" size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3D"Courier New" size=3D2>Thanks,</FONT></DIV>
<DIV><FONT size=3D2><FONT face=3D"Courier New">Chris</FONT></DIV>
<DIV><FONT face=3D"Courier New"><BR></FONT></DIV></FONT></BODY></HTML>

------=_NextPart_000_000A_01C39A4C.4F6E8160--