Re: [mapserver-users] problem with join

[Richard Greenwood <Rich@GreenwoodMap.com>]

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@GreenwoodMap.com
(307) 733-0203
http://www.GreenwoodMap.com