Ticket #4077 (closed defect: fixed)

Opened 3 years ago

Last modified 3 years ago

Join Documentation Changes Needed

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

Description

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

Change History

Changed 3 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?

Changed 3 years ago by 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

Changed 3 years ago by havatv

  • status changed from new to closed
  • resolution set to fixed

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

Note: See TracTickets for help on using tickets.