MyQL join error

[Dan Liu]

Hi all,

I am trying MySQL Join with dbase shapefile. The errors I get are:

 

Error in msDrawMap(): Failed to draw layer named 'county'.
Error in msDBFGetItemIndex(): Item 'JOIN1_num' not found.

 

Below is the layer with JOIN in map file. Does anybody know what is
wrong?  Thanks.

 

LAYER

NAME county

TYPE POLYGON

STATUS DEFAULT

DATA county

CLASSITEM MLMIS_CTY  

 

  JOIN

    CONNECTIONTYPE mysql

    CONNECTION "localhost:myusername:mypw:dbname"

 

    TABLE "county"

    TO "num"

    NAME "JOIN1"

    FROM "MLMIS_CTY"

  END

 

  CLASS

    NAME "class 6"  

    EXPRESSION ([JOIN1_num]>30)

    COLOR 236 0 0

    OUTLINECOLOR 0 0 0

  END

.

.

.

 

Dan

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