[mapserver-users] OGR shapefile w/MySQL Join

[Steve Lime]

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 <4A9FC5D4.9050802 at mapgears.com>, Daniel
Morissette <dmorissette at mapgears.com> 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