Re: [UMN_MAPSERVER-USERS] join with dbf file

[Richard Greenwood]

On 5/14/07, Fischer, Brian <[EMAIL PROTECTED]> wrote:

Rich,

You are correct, I am just trying to display attribute data from the
join table.

-Brian

I don't know if this will help, but here is an example of displaying
attribute data from a one-to-many relationship:


LAYER
        NAME  "join"
        GROUP "ownership"
        STATUS ON
        TYPE POLYGON
        PROJECTION
                "init=epsg:2241" # NAD83 / Idaho East (ftUS)
        END
        DATA  "join"
        HEADER "attribute_header.html"
        FOOTER "attribute_footer.html"
        TEMPLATE "attribute_display.html"
        JOIN    # JOIN no longer lives inside of CLASS or inside a QUERY object
                NAME "cats"
                TABLE "/Inetpub/wwwroot/mapserver/fc/data/cat.DBF"
                FROM DESCRIPTOR
                TO      PIDN
                TYPE  one-to-many # multiple
                TEMPLATE  cat.html      # required only for one-to-many joins
        END # of JOIN Object
        CLASSITEM "CLERK_REC"
        CLASS
                Name "Lot and Parcel Lines"
                SYMBOL "Solid"
                OUTLINECOLOR 0 0 0
                SIZE 2
        END  # class
END  # layer join

cat.html:

<TR><TD>[cats_ACRES]&nbsp;</TD><TD>Acres&nbsp;</TD><TD>[cats_CATEGORY]</TD></TR>


--
Richard Greenwood
[EMAIL PROTECTED]
www.greenwoodmap.com