One to many joins

Erich Schroeder erich at museum.state.il.us
Tue Feb 22 09:40:55 EST 2000


Steve,
  That worked just fine. The layer snippet now looks like:

LAYER
  NAME zips
  TYPE POINT
  STATUS ON
  DATA zips
  CLASS
    SYMBOL 3
    COLOR 0 0 255
    NAME "IAM Museums"
    EXPRESSION ([MUSEUM] > 0)
  END # class
  QUERYITEM "ZIPCODE"
  QUERY
   EXPRESSION ([MUSEUM] > 0)
   template museums.html
   JOIN
     template museum_detail.html
     name "museumdetail"
     type multiple
     table "museums.dbf"
     from "ZIPCODE"
     to "ZIP"
   END # join
 END # query
END

Thanks for the prompt answer.

Erich

---------------------------------------------------------------------
Erich Schroeder                    Phone: (217)785-0033
Curator, Information Technologies  FAX:   (217)785-2857
Illinois State Museum GIS Lab      Internet: erich at museum.state.il.us
http://www.museum.state.il.us/ismdepts/anthro/staff/erich/erich.html
---------------------------------------------------------------------




More information about the mapserver-users mailing list