Opened 6 years ago

Closed 6 years ago

#4077 closed defect (fixed)

Join Documentation Changes Needed

Reported by: sdlime Owned by: jmckenna
Priority: normal Milestone:
Component: Documentation - MapServer Version: unspecified
Severity: normal Keywords:
Cc: sdlime, havatv


There are a couple of problems in the JOIN object documentation (

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.


Change History (3)

comment:1 Changed 6 years ago by havatv

Cc: sdlime havatv added

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?

comment:2 Changed 6 years ago by sdlime

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

Here's a sample for MySQL:

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


comment:3 Changed 6 years ago by havatv

Resolution: fixed
Status: newclosed

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

Note: See TracTickets for help on using tickets.