<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2722" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Tahoma size=2><SPAN class=963472514-15092005>Hi
List</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=963472514-15092005></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=963472514-15092005>I'm am trying to
build a layer using </SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=963472514-15092005>- tiled
shapefiles</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=963472514-15092005> (using
TILEINDEX and TILEITEM)</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=963472514-15092005>- a one-to-many
join.</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=963472514-15092005></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=963472514-15092005>Unfortunately this
does not work.</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=963472514-15092005>I get an error
message when quering: <FONT face="Times New Roman" size=3>"Content-type:
text/html <!-- MapServer version 4.2.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP OUTPUT=PDF OUTPUT=SWF SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT INPUT=EPPL7 INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE -->msDBFJoinConnect():
Join error. Item PLANIDID not found in layer
TestJoin."</FONT></SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=963472514-15092005>However I am
absolutely sure the column "PLANIDID" does exist in all the shapefiles (yes in
uppercase).</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=963472514-15092005></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=963472514-15092005>If I replace the
tiled shapefiles for a single shapefile, all is fine.</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=963472514-15092005></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=963472514-15092005>If I replace the
one-to-many for a one-to-one join (including adapting the query template),
all is fine too.</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=963472514-15092005></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=963472514-15092005>It seems to me that
mapserver tries to read the tileindex itself to establish a
join.</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=963472514-15092005></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=963472514-15092005>Is this a bug, or
did I mis something?</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=963472514-15092005></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=963472514-15092005></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma size=2></FONT> </DIV>
<DIV><FONT face=Tahoma size=2></FONT> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=963472514-15092005>Remy van
Oosterhoudt</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=963472514-15092005>GEON
bv</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=963472514-15092005>email:<SPAN
style="mso-tab-count: 1"> <A
href="mailto:R.van.Oosterhoudt@geon.nl">R.van.Oosterhoudt</SPAN>@geon.nl</A><BR>internet:<SPAN
style="mso-tab-count: 1">
</SPAN>www.geon.nl <?xml:namespace prefix = o ns =
"urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2></FONT> </DIV></BODY></HTML>