no, the joined fields are just available for display of query results (therefore called "RESULT_JOIN") and is only executed when composing the result list. But it is not available to the pure Mapserver/Mapscript base that is used for map rendering.
but you can try the Mapserver join definitions like described here: http://mapserver.org/mapfile/join.html This was not existing when working on the first releases of pmapper, but I guess now it makes the pmapper-specific join definitions somehow obsolete (at least for Postgres and Mysql). and it seems to allow also 1-to-many joins armin On Fri, Jun 18, 2010 at 9:02 PM, Marcello Benigno <benigno.marce...@gmail.com> wrote: > Hi all, > > Is it possible create a tematic map from mysql table data? For example: > > METADATA > "DESCRIPTION" "Hidrografia" > "RESULT_JOIN" "mysql://root:passw...@localhost/hidroambiental||drena...@id > @0...@nome_rio,ordem_rio||OBJECTID||0" > "RESULT_HEADERS" "id,nome,ordem_rio" > END > > And use: > > CLASSITEM 'ordem_rio' > > Is there a way for do it? > > Thanks in advance, > > -- > Marcello Benigno B. de Barros Filho > Prof. do Curso Superior de Tecnologia em Geoprocessamento - IFPB > Mestre em Ciências Geodésicas e Tecnologias da Geoinformação - UFPE > http://profmarcello.blogspot.com > ------------------------------------------------------------------------------ > ThinkGeek and WIRED's GeekDad team up for the Ultimate > GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the > lucky parental unit. See the prize list and enter to win: > http://p.sf.net/sfu/thinkgeek-promo > _______________________________________________ > pmapper-users mailing list > pmapper-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/pmapper-users > ------------------------------------------------------------------------------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
