mapfile join

Brent Lund Brent.Lund at STATE.MN.US
Thu Feb 17 13:28:15 EST 2005


All:

I am attempting to do a multiple join with a dbf file.   I am able to do
a single join where the map and template file look like:


...
  TEMPLATE test.html
  JOIN
    NAME myJOIN  
  #  TYPE multiple
  #  TEMPLATE info.html
    TABLE mydbf.dbf
    FROM joinfield
    TO joinfield
  END 
...


test.html looks like

[myJOIN_COUNTY]<p>
[join_myJOIN] <!-- for multi join --> <p>
[myJOIN_USGS]<p>



The result query looks like:


Kanabec

[join_myJOIN]

Grasston



When the comments are removed from the JOIN object (making a multi
query) the result looks like


[myJOIN_COUNTY]





The application I have was originally written for mapserver 3.3  -
Figured it was high time to update to 4.4.1.

Thanks

Brent



More information about the mapserver-users mailing list