mapfile join

[John Spotten]

Hi,

looking for some sample code showing a join use successfully. get a parsing error when using it under class.  put it under layer, no parsing error but then  XP tells me mapserv.exe has found a problem and is closing down.  using mapserver 4.4.0 on XP and I get error on html page msDBFJoinConnect(): Unable to access file. (c:\ms4w\apps\mapserver_demos\ct\data\join.dbf).  any clues.    can i use a dbf file.

I am trying to join to a shape file a seperate independent dbf file on a common field that is indexed in the shape file.  the field is text type.

I take it it can be accessed using the [join_<join_name>] template in a query template file for a one to many join where [join_<join_name>] gets replaced with the join header template and footer files and I assume that the template within the query template file is [<join_name>_<dbf_field_name>].

Is it possible to refer to the qlayer as [join_<join_name>]? 

bye 
john

John Spotten
Transport Modeller/GIS Developer
Directorate of Transport, Roads and Stormwater
City of Cape Town
Tel : +27 21 4067325
Fax : +27 21 4186989
Cell : +27 846678901
Email : john.spotten at capetown.gov.za
Web : www.capetown.gov.za
 <<John Spotten.vcf>> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20050126/f399a21f/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: John Spotten.vcf
Type: text/x-vcard
Size: 226 bytes
Desc: John Spotten.vcf
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20050126/f399a21f/attachment.vcf>
-------------- next part --------------
NOTE:  This e-mail (including attachments) is subject to the restrictions, qualifications
 and disclaimers (?disclaimer?) published at www.capetown.gov.za/disclaimer/email.pdf.
Please read the disclaimer before opening any attachment or taking any other action in
terms of this e-mail. If you cannot access the disclaimer, kindly send an email to
infomail at capetown.gov.za and a copy will be provided to you. By acting on this e-mail
or opening any attachment you agree to be bound by the provisions of the disclaimer.

-------------------------------------------------