Re: [UMN_MAPSERVER-USERS] Query JOIN table between SHP and MySQL

[Frank Warmerdam]

Bayu Kurniawan R wrote:

How to join between ESRI Shapefile data with MySQL data
I'm try with http://mapserver.gis.umn.edu/docs/reference/mapfile/join

 JOIN
        NAME "DEMO"
        CONNECTION "MYSQL:DEMO,host=localhost,port=3306,user=root,password="
        CONNECTIONTYPE ogr
        TABLE "Gabungan"
        FROM "Kecamatan"
        TO "kecamatan"
        TYPE ONE-TO-ONE
    END

but my query is no result

Bayu,

It was my understanding that the JOIN declaration in the mapfile only works
for dbf files, not ogr datasources though I could be wrong.

Best regards,
--
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, [EMAIL PROTECTED]
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | President OSGeo, http://osgeo.org