[mapserver-users] problem with join

[Richard Greenwood]

You can create a join in your map file. Here's an example:

Class
    Join
      from PIDN
       name jointest
       table "\Tc\DATA\assessor.DBF"
       # TEMPLATE join_region.shp_query.html  # required only for 
one-to-many joins
       to        Pidn
       type  single
    End # of Join Object
    SYMBOL "Solid"
   OUTLINECOLOR 0 0 0
END # of Class

This is pretty well documented. Be careful how much editing is done to the 
dbf - adding or deleting records will break the join.

Also note that you can only use a join for queries, not labeling. If you 
need to label features off the dbf you are out of luck. You will need to 
create the join in ArcView or MapInfo, and save it out as a single, static 
layer.

Rich


At 11:54 AM 3/4/2002 +0100, you wrote:
>hi,
>
>my (little) problem:
>
>i have a shape and i have ab big dbf-file.
>the polys in the shape have 1 (one!)  item - the ID , all other dates are 
>in the dbf (landuse, name, number, ........)
>i want to join both files to shade the poly in different views (first 
>landuse, later name, ....)
>my users should only edit in the dbf-file!
>
>and now my problem: how must I join to shade different with datas from the 
>joined dbf???
>who has an example for me (map-file?)
>
>great thanks.
>mikeE.:-)


Richard W. Greenwood, PLS
Greenwood Mapping, Inc.
Rich at GreenwoodMap.com
(307) 733-0203
http://www.GreenwoodMap.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20020304/283aebe8/attachment.html