Flavio,
Take a look at this page if you haven't: http://mapserver.org/mapfile/join.html
Under 'Description', it mentions that you can't use joined data to 'affect the
look of a map'. I am pretty sure that this rules out your case.
David.
-Original Message-
From: mapserver-users-boun
Hello Flavio,
As noted on the page you referred to, this JOIN only works for executed
queries...and I do not see a TEMPLATE in your layer. Are you aware that
this join only works for queries? (see the examples in that documentation)
-jeff
--
Jeff McKenna
MapServer Consulting and Training
Flavio,
Column names are case sensitive, have you checked this ?
Cheers from México
IC Carlos Ruiz
From: flaviocarmo
To: mapserver-users@lists.osgeo.org
Sent: Mon, November 29, 2010 8:43:44 AM
Subject: [mapserver-users] Join from SHP file to PostgreSQL table
Flavio,
I think that if you have CONNECTIONTYPE OGR, the connection string
must have "PG:" (unlike the native mapserver Postgres connections?):
CONNECTIONTYPE ogr
CONNECTION "PG:dbname='testdb' host=GSERVER1 port=5432 user='test'
password='test' sslmode=disable"
If this works let