<div dir="ltr">For the sake of completeness, "$value" is the default format and doesn't need to be explicitly set. --Steve</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Nov 20, 2019 at 7:29 AM Rahkonen Jukka (MML) <<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi">jukka.rahkonen@maanmittauslaitos.fi</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="FI">
<div class="gmail-m_757538910375480729WordSection1">
<p class="MsoNormal">Hi Markus,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span lang="EN-US">I am not sure if you’d prefer me to answer in Finnish but English is easier for the majority of readers.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Certainly it is possible to use data from a database with templates yes but you did not tell the details about for what purpose you are trying to use the templates. The DATA (perhaps with CONNECTION) that is used in LAYER
<a href="https://mapserver.org/mapfile/layer.html" target="_blank">https://mapserver.org/mapfile/layer.html</a> can also be used as a data source for templates.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">An example from an old mail <a href="http://osgeo-org.1560.x6.nabble.com/html-tags-in-GetFeatureInfo-td5224781.html" target="_blank">
http://osgeo-org.1560.x6.nabble.com/html-tags-in-GetFeatureInfo-td5224781.html</a> contains a template that defines the html format of GetFeatureInfo. Each “item name” is a name of the attribute in the source data. If vector data for the LAYER comes from MYSQL
then the attributes are read from MYSQL as well. <u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><body> <br>
<h3>NIMI</h3> <br>
[item name=NIMI format="$value" escape=none] <br>
<h3>LISÄTIEDOT</h3> <br>
[item name=KIELLONLISATIETO format="$value" escape=none] <br>
<h3>VOIMASSAOLO</h3> <br>
[item name=VOIMASSAOLO format="$value" escape=none] <br>
<h3>YHTEYSTIEDOT</h3> <br>
[item name=YHTEYSTIEDOT format="$value" escape=none] <br>
</body><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">-Jukka Rahkonen-</span><span lang="EN-US"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<div>
<div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(225,225,225);padding:3pt 0cm 0cm">
<p class="MsoNormal"><b><span>Lähettäjä:</span></b><span> mapserver-users <<a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a>>
<b>Puolesta </b>Markus Lütke Brintrup<br>
<b>Lähetetty:</b> keskiviikko 20. marraskuuta 2019 14.53<br>
<b>Vastaanottaja:</b> <a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br>
<b>Aihe:</b> [mapserver-users] Info Template<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span lang="DE">Hallo Liste,<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="DE">besteht die Möglichkeit in der Template.html eines Map-Projektes eine Datenbankanbindung an zu steuern?<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE">Beispiel:<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE"><tr><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE"> <td><b>Projektname:</b></td><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE"> <td>[Werte aus MYSQL-DB]</td> <u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE"></tr><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="DE">Freundliche Grüße<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="DE">Markus Lütke Brintrup<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="DE">WipflerPLAN<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE">Niederlassung Donauries<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="DE">Telefon: 09081 27509-44<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE">Telefax: 09081 27509-50<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE" style="color:blue"><a href="mailto:mlb@wipflerplan.de" target="_blank"><span style="color:blue">mlb@wipflerplan.de</span></a><u></u><u></u></span></p>
<p class="MsoNormal"><u><span lang="DE" style="color:blue"><a href="http://www.wipflerplan.de/" target="_blank"><span style="color:blue">www.wipflerplan.de</span></a></span></u><span lang="DE" style="color:blue"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="DE" style="font-size:9pt">WipflerPLAN Planungsgesellschaft mbH<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE" style="font-size:9pt">Standort Nördlingen<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE" style="font-size:9pt">An der Lach 11a<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE" style="font-size:9pt">86720 Nördlingen<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE" style="font-size:9pt">Amtsgericht Ingolstadt HRB 190595<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE" style="font-size:9pt">Geschäftsführer:<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE" style="font-size:9pt">Wilhelm Wipfler<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE" style="font-size:9pt">Ursula Burkart<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE" style="font-size:9pt">Adelheid Buchard
<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="DE"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="DE"><u></u> <u></u></span></p>
</div>
</div>
_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/mapserver-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/mapserver-users</a></blockquote></div>