[mapserver-users] Can't get JOIN to work with Postgis

[Ganaël Jatteau]

Hi,

 

I'm trying to use the tag JOIN in a layer in order to join two tables in
POSTGIS. 

 

The layer gets displayed on the map but it seems that the join is ignored (a
subset of the layer should be displayed normally after the join and when I
select some features I don’t see the attributes from the join table).

 

BTW: I use MapServer 5.2.1 on Windows

 

Is there anything wrong with the layer that has been defined:

 

LAYER

    CONNECTION "host=localhost user=scott dbname=basepiad password='tiger'

    CONNECTIONTYPE POSTGIS

    DATA "the_geom from dept_aquitaine using unique oid using SRID=27581"

      CLASS

      NAME "classe"

      STYLE

        ANGLE 360

        COLOR 255 255 255

        OPACITY 100

        OUTLINECOLOR 180 180 180

        SYMBOL 0

      END

    END

    JOIN

      NAME "test_join"

      TABLE "webigeo.wap1"

      FROM "code_depar"

        TO "f0"

      TYPE ONE-TO-ONE

    END

    NAME "departements_join"

    STATUS ON

    TEMPLATE "ttt"

    TYPE POLYGON

    UNITS METERS

  END

 

 

Thanks in advance.

 

Ganaël

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20090703/f72befe1/attachment.htm>