[mapserver-users] question about joining

[Jeff McKenna]

Hi Mark,

Your interpretation of the existing JOIN documentation 
(http://www.mapserver.org/mapfile/join.html) is correct, you can only 
use the JOIN feature for query templates.

-jeff


-- 
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/




On 10-10-26 12:28 PM, Mark Volz wrote:
> Hello,
>
> I have not used the Join shapefile to database function in mapserver
> before. I just have a couple questions
>
> ·The description explains that“It is important to understand that JOINs
> are/ONLY/available once a query has been processed. You cannot use joins
> to affect the look of a map.”Does that mean that we can only use the
> joins for templates. If possible, I would like tolabel using a field in
> a joined table.
>
> ·Is the following formatted correctly
>
> #CLASSITEM 'PARC_CODE'
>
> JOIN #TEST
>
> NAME "MyJoin"
>
> TABLE "LyonCounty/Parcels/test.dbf"#location of the dbf file
>
> FROM "PARCEL_ID"#shapefile field
>
> TO "PIN"#dbf field
>
> TYPE ONE-TO-ONE
>
> END #JOIN
>
> …
>
> TEXT (“Name”* [MyJoin_MYNAME]) #labelusing the joined table
>
> Thanks
>
> Mark Volz
>
> GIS Specialist
>
> Lyon County, MN
>