Join Documentation Changes Needed

[sdlime]

There are a couple of problems in the JOIN object documentation (http://mapserver.org/mapfile/join.html).

First, we also support MySQL joins so that needs to be added. Connection type is MYSQL. I'll post an example connection string as soon as I can get to my test box.

Second, in example 2 there the CONNECTIONTYPE is set to OGR when it should be POSTGRESQL.

Steve

[havatv]

I have added MySQL, and have changed ogr to postgresql in r12860. Your MySQL example is needed to close the ticket, Steve (I don't have MySQL installed).

Question: In example 3 (a csv join), the JOIN object does not have a CONNECTIONTYPE parameter. This is not consistent with the documentation. What to do?

[sdlime]

Example 3 is incomplete, just need to add "CONNECTIONTYPE CSV" to that snippet.

Here's a sample for MySQL:

JOIN
  NAME 'mysql-join'
  CONNECTIONTYPE MYSQL
  CONNECTION 'server:user:password:database'
  TABLE 'mysql-tablename'
  FROM 'layer-column'
  TO 'mysql-column'
END

Steve

[havatv]

Thanks, Steve. I have added the example and fixed the CVS example in r12870. Closing.