Opened 4 years ago

Closed 4 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

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 (3)

comment:1 Changed 4 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 4 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

comment:3 Changed 4 years ago by havatv

  • Resolution set to fixed
  • Status changed from new to closed

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

Note: See TracTickets for help on using tickets.