Luca, your layer is part of a group. For groups, the first layer (in the order of the map file) is taken for both the header and the result fields, for all layers that are part of this group. So this might be the reason why fields configured for your layer are not taken into account.
One could change this in principle but my usage of groups might be a bit different from that of others, who might want to use them more in the sense of a thematic category. I always wanted to have the results of all layers of a group together. In your case, you should consider putting layers with different fields in different groups, but together in the same category. I know that this has the disadvantage that they are not dis/activated at the same time, but it's a limitation of the current application. armin luca marletta wrote: > Hi all, > just now I try to perform some test with the pmapper function for > joining mysql table. > I got some result but there is something that woks not as expected. > > here is my mapfile > > LAYER > NAME "mysqltest" > GROUP "cartografia" > STATUS ON > DATA "/var/www/map/dati/mysqljointest" > TYPE POLYGON > MINSCALE 400 > TRANSPARENCY 70 > TEMPLATE void > METADATA > "DESCRIPTION" "mysqljointtest" > "RESULT_FIELDS" "ED,DESCRIZIONE" > "RESULT_HEADERS" "Descrizione,MySQL" > "RESULT_JOIN" > "mysql://<user>:<password>@localhost/joinpmapper||pmapper at [EMAIL > PROTECTED] at DESCRIZIONE||ED||1" > END > CLASS > NAME "mysqltest" > STYLE > COLOR 255 0 0 > OUTLINECOLOR 0 0 0 > END > END > END > > I've prepared a shape field on purpose with the filed for joining as > number and works well for the main part > > the problem is that the "RESULT_HEADERS" "Descrizione,MySQL" doesn't work > (there are not the new header I added) and also the "RESULT_FIELDS" > "ED,DESCRIZIONE" seems strange because I got 3 fields not 2, and the > order is not as planned > > first I suggest for testing to use not a text field for join on > because char coding play tricks > > I'll go on with some test and after I will write the result on wiki > and I'm also wondering why others don't do it. > for who don't know wiki are software for manage multi authoring, that > is the purpose. > everyone can register and get e password and I'm sure that Armin is > not jealous of that space if someone try to write also for not > completely correct lines. > > luca >