[Mapserver-users] OGR layer and JOIN {Scanned}

[Siki Zoltan]

Hi list,

Is it possible to JOIN a dbf file to an OGR layer?
Is there any case rule (lower/uppercase) for column names?
Somewhere in the docs/wiki I read uppercase sould be used.
It is not true for OGR layers, I must use the same case as in the
original table definition.
I failed to connect a mapinfo tab to a dbf file. In the query
result I got [column_name] instead of the value. Can you chek my try?

Thanx
Zoltan

layer definition in map file

LAYER
	NAME "telek"
	CONNECTIONTYPE OGR
	CONNECTION "teljes/telek.tab"
	STATUS ON
	GROUP "telkek"
	TYPE POLYGON
	CLASS
		EXPRESSION ([KOZTER_KOD]=0)
		NAME 'Magánterület'
		COLOR -1 -1 -1
		OUTLINECOLOR 0 0 0
		TEMPLATE "telek_cim.html"
	END
	CLASS
		EXPRESSION ([KOZTER_KOD]=1 OR [KOZTER_KOD]=2)
		NAME 'Közterület'
		COLOR 198 198 198
#		TRANSPARENCY 75
		OUTLINECOLOR 0 0 0
		TEMPLATE "telek_cim.html"
	END
	HEADER "telek_cim_header.html"
	FOOTER "telek_cim_footer.html"
	JOIN
		NAME telekcim
		FROM hrsz
		TABLE "cim/cim1.dbf"
		TO HRSZ
	END
END

The template (telek_cim.html)

<tr>
	<td valign="top">[hrsz]&nbsp;</td>
	<td valign="top" align="right">&nbsp;[kozter_kod]</td>
	<td valign="top">&nbsp;[telekcim_kozternev]</td>
	<td valign="top">&nbsp;[telekcim_tipusnev]</td>
	<td valign="top">&nbsp;[telekcim_hazszam]</td>
	<td valign="top" align="right">&nbsp;[terulet]</td>
	<td valign="top">&nbsp;</a></td>
</tr>