multiple join - shp to dbf {Scanned}

[Siki Zoltan]

Hi,

First of all, you can only use mapserver join for querying purpose.
I use ONE TO MANY join, it works on linux, but frequently failes on
windows. I have also tried to use OGR join to create thematic map on the
column of the joined table (see my previous post). So far I get no 
working map file, no error and no result :(

Bye
Zoltan

Sample for multiple join:
Layer definition in map file:

LAYER
	NAME "kafold"
	DATA "alapterkep/kafold"
	STATUS ON
	TYPE POLYGON
	CLASS
		STYLE
			COLOR -1 -1 -1
		END
		STYLE
			OUTLINECOLOR 0 0 0
		END
	END
	HEADER "telek_cim_header.html"
	TEMPLATE "telek_cim.html"
	FOOTER "telek_cim_footer.html"
	
	JOIN
		NAME cim
		TABLE "cimek/ujcimek1.dbf"
		FROM HRSZ
		TO HRSZ
		TYPE multiple
		TEMPLATE "cim_template.html"
	END
END

template for the layer (one row only)

[join_cim]

template for multiple join, note joined columns
start with the join name ("cim_" in my case)

<tr>
	<td valign="top">[HRSZ]</td>
	<td valign="top" align="right">[JOGTER]</td>
	<td valign="top"> [F_TIP]</td>
	<td valign="top"> [VALTSZ]</td>
	<td valign="top"> [cim_IRSZAM]</td>
	<td valign="top"> [cim_CIM]</td>
	<td valign="top"> [cim_HATSZAM]</td>
</tr>

kafold table has HRSZ, JOGTER, F_TIP, VALTSZ columns
ujcimek1 table has IRSZAM, CIM, HATSZAM columns


On Thu, 2 Jun 2005, william paul wrote:

> Hi:
> I want to join a shp file with a dbf file. It's ONE TO MANY join. I have seen that more people have the same problem. Also I want to make a classification based on the attributes from the DBF file. I tried with OGR and JOIN OBJECT from Mapserver, but nothing
> 
> Does any one have a working example?
> 
> Thank you in advance
> 
> William
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com