Re: [pmapper-users] Attribute search example with MySQL table

2010-08-25 Thread Dejan Gambin
Armin, Thanks for the information. Do you think it would be possible to use native MapServer joins for this, like described here: http://mapserver.org/mapfile/join.html and use MySQL fields in RESULT_FIELDS? I suppose not... regards, dejan On 25. kol. 2010., at 19:28, Armin Burger wrote:

Re: [pmapper-users] Attribute search example with MySQL table

2010-08-25 Thread Armin Burger
I updated the docs for this issue, see "limitations" part at http://svn.pmapper.net/trac/wiki/DocManual?version=77#JoiningDatabasetablestolayers armin On 24/08/2010 13:07, Dejan Gambin wrote: > Hi, > > I have successfully made a join from shape file to MySQL database using > RESULT_JOIN syntax

[pmapper-users] Attribute search example with MySQL table

2010-08-24 Thread Dejan Gambin
Hi, I have successfully made a join from shape file to MySQL database using RESULT_JOIN syntax like this: "RESULT_JOIN" "mysql://user:pas...@localhost/database_name||table_n...@table_join_field@1...@name,owner||SHAPE_JOIN_FIELD||1" I have also slightly modified sqery.php so that one-to-