Re: [pmapper-users] CLASSITEM from MySQL Table

2010-06-18 Thread Armin Burger
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 l

[pmapper-users] CLASSITEM from MySQL Table

2010-06-18 Thread Marcello Benigno
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 'ord