RE: [mapserver-users] Join from SHP file to PostgreSQL table

2010-11-29 Thread Fawcett, David (MPCA)
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:

Re: [mapserver-users] Join from SHP file to PostgreSQL table

2010-11-29 Thread Jeff McKenna
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

Re: [mapserver-users] Join from SHP file to PostgreSQL table

2010-11-29 Thread Carlos Ruiz
Flavio, Column names are case sensitive, have you checked this ? Cheers from México IC Carlos Ruiz From: flaviocarmo flavio.o.ca...@gmail.com To: mapserver-users@lists.osgeo.org Sent: Mon, November 29, 2010 8:43:44 AM Subject: [mapserver-users] Join from SHP

Re: [mapserver-users] Join from SHP file to PostgreSQL table

2010-11-29 Thread Brent Fraser
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 me