Well in my mapfile i've this select <br><br>DATA "the_geom FROM (select comune, DCA01_01 as Abitazioni_Totali, DCA02_01 as Abitazioni_Residenti, DCA03_01 as Abitazioni_Non_residenti, DCA04_01 as Abitazioni_vuote, the_geom, gid from abitazioni) AS abitazioni1 USING UNIQUE gid USING SRID=-1"
<br><br>but in my query result i can still see SHAPE_INDEX, TILE_INDEX,LAYER_INDEX<br><br>Why?? <br><br><div><span class="gmail_quote">2006/6/6, Julien-Samuel Lacroix <<a href="mailto:jlacroix@mapgears.com">jlacroix@mapgears.com
</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi,<br>With the new QueryResult.phtml you can specify which field will be shown
<br>directly in your mapfile or in the Query widget.<br><br>In your mapfile, in the layer, you can use the HEADER parameter like this:<br>HEADER "Field^Title in the result table|Field^Title"<br>Example: HEADER "NAME^Name|UNIQUE_KEY^Key"
<br><br>In your widget you can use:<br><CWC2 Type="Query"...><br> <TABLEHEADER LAYER="popplace" HEADER="NAME^Name|UNIQUE_KEY^Key"/><br></CWC2><br><br>If you still want to change the .phtml go around line 294, the field
<br>shown are defined here:<br><br>foreach ($aRows[0] as $key => $value)<br>{<br> $aszHeaderNames["$key"] = $key;<br>}<br><br>Julien<br><br>listserver server wrote:<br>> Updating to the last version of chameleon i've noted that
<br>> queryreult.phtml is completely different from the previous version!<br>><br>> In the previous version i added this lines for 2 reason, to remove<br>> SHAPE_INDEX, TILE_INDEX,LAYER_INDEX from query result and for format
<br>> http header.<br>><br>> // loop and add a cell for each result<br>> foreach ( $aRow as $key => $xCell )<br>> {<br>> //String comparison to search for fields that should NOT be returned in query results.
<br>> if (strcasecmp($key, "SHAPE_INDEX") == 0 ||<br>><br>> strcasecmp($key, "TILE_INDEX") == 0 ||<br>> strcasecmp($key, "LAYER_INDEX") == 0)<br>> continue;
<br>> {<br>> //Look for strings containing an http header. If exists then format as a link, if not format as normal text.<br>><br>> if ( stristr ($xCell, 'http://' <http://%27/> ))
<br>> $szReturnValue .= "<td class=\"subContentArea1\"><p<br>> class=\"text\"><a href='". $xCell."' target='_blank'>Click here for more<br>><br>> information</a></p></td>\n";
<br>> else<br>> $szReturnValue .= "<td class=\"subContentArea1\"><p<br>> class=\"text\">". $xCell."</p></td>\n";<br>><br>
> }<br>> }<br>> $szReturnValue .= "</tr>\n";<br>> }<br>><br>><br>> Can be done something similar also in new queryresult.phtml ??<br>
><br>><br>><br>> ------------------------------------------------------------------------<br>><br>> _______________________________________________<br>> Chameleon mailing list<br>> <a href="mailto:Chameleon@lists.maptools.org">
Chameleon@lists.maptools.org</a><br>> <a href="http://lists.maptools.org/mailman/listinfo/chameleon">http://lists.maptools.org/mailman/listinfo/chameleon</a><br><br>--<br>Julien-Samuel Lacroix<br>Mapgears<br><a href="http://www.mapgears.com/">
http://www.mapgears.com/</a><br></blockquote></div><br>