JOIN object usage in a mapfile

[Jeff McKenna]

Hello everyone,

For the first time I am trying to use the mapfile JOIN object, and I 
can't seem to get it to work.  From the mapjoin.c file I can see that 
DBF, CSV, PostgreSQL, and MySQL are supported.  I have personally tried 
to view query results joined from DBF, CSV, and PostgreSQL tables 
unsucessfully.  (my goal is to also update the sparse documentation for 
this also on http://mapserver.gis.umn.edu/docs/reference/mapfile/join). 
  Here is my DBF test case:

Test Environment
****************

mapserver 4.10.0
windows

mapfile layer
*************

LAYER
   NAME prov_bound
   TYPE POLYGON
   STATUS DEFAULT
   DATA prov
   CLASS
     NAME "Province"
     STYLE
       OUTLINECOLOR 120 120 120
       COLOR 255 255 0
     END
   END
   TEMPLATE "../htdocs/cgi-query-templates/prov.html"
   HEADER "../htdocs/cgi-query-templates/prov-header.html"
   FOOTER "../htdocs/cgi-query-templates/footer.html"
   JOIN
     NAME "test"
     TABLE "../data/lookup.dbf"
     FROM "ID"
     TO "IDENT"
     TYPE ONE-TO-ONE
   END
END # layer

ogrinfo
*******

 >ogrinfo lookup.dbf lookup -summary
INFO: Open of `lookup.dbf'
using driver `ESRI Shapefile' successful.

Layer name: lookup
Geometry: None
Feature Count: 12
Layer SRS WKT:
(unknown)
IDENT: Integer (2.0)
VAL: Integer (2.0)

 >ogrinfo prov.shp prov -summary
INFO: Open of `prov.shp'
using driver `ESRI Shapefile' successful.

Layer name: prov
Geometry: Polygon
Feature Count: 12
Extent: (-2340603.750000, -719746.062500) - (3009430.500000, 3836605.250000)
Layer SRS WKT:
(unknown)
NAME: String (30.0)
ID: Integer (2.0)


Template
********

<tr bgcolor="#EFEFEF"><td align="left">[NAME]</td><td 
align="left">[VAL]</td></tr>

Query Results
*************

Layer: Provinces

NAME	VAL
====    ====
Ontario	[VAL]	

Other Notes
***********

- the join seems to be happening, because if I specify false FROM/TO 
values errors are thrown, yet I cannot get values to appear from the 
[VAL] field
- ID/IDENT are integer values from 1 to 12
- the join works with desktop GIS packages


Can someone see what I am doing wrong?

thanks.

jeff


-- 
Jeff McKenna
DM Solutions Group Inc.
http://www.dmsolutions.ca