Re: [pmapper-users] CLASSITEM from MySQL Table

[Armin B. <arm...@gm...>]

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
<ben...@gm...> wrote:
> Hi all,
>
> Is it possible create a tematic map from mysql table data? For example:
>
> METADATA
> "DESCRIPTION" "Hidrografia"
> "RESULT_JOIN" "mysql://root:password@localhost/hidroambiental||drenagem@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
> pma...@li...
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>