Thanks, didn't search on the right terms. Lot's of "in theory"'s... Will give it a try. Fortunately I only have 60 records so sucky performance may be tolerable.
Steve >>> On 9/3/2009 at 8:34 AM, in message <[email protected]>, Daniel Morissette <[email protected]> wrote: > Steve Lime wrote: >> This isn't an instance where a JOIN block is particularly useful. I need the >> MySQL attributes for map making and JOINs are only used with query >> results. Plus the MySQL join driver assumes integer keys and I have strings. >> Hence my hope to do the join in OGR before the data even hit MapServer. >> > > Here is a post by Frank from a couple of years ago that explains how to > join shapefile and ODBC data with an OGR SQL statement in the layer's > DATA parameter: > > http://lists.osgeo.org/pipermail/mapserver-users/2004-November/002149.html > > It should be easy to adapt this example to connect to MySQL instead of > ODBC for the join, but I didn't test it myself. (The MySQL driver docs > are at http://gdal.org/ogr/drv_mysql.html) > > Daniel _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
