Modèle:Unités-complet-case-titre-desc-fr : Différence entre versions

Version actuelle en date du 17 juillet 2014 à 13:03

Error: no local variable "abrev_part1" was set.Error: no local variable "abrev_part2" was set.

Error: no local variable "nomunit_fr" was set.

Error: no local variable "descunit_fr" was set.

@@ Ligne 1 : / Ligne 1 : @@
+{{#get_db_data:
+db=geolwiki
+|from=stratunit
+|where=codestratunit='{{{1}}}'
+|data=codestratunit=codestratunit,abrevstrat2=abrevstrat2,abrevstrat=abrevstrat,nomunit_fr=nomunit_fr,nomunit_de=nomunit_de,
+ordrestrat=ordrestrat,abrev_part1=abrev_part1,abrev_part2=abrev_part2,descunit_fr=descunit_fr,descunit_de=descunit_de,autrenom=autrenom,
+ep_minmax=ep_minmax,r255=r255,g255=g255,b255=b255,
+grouping1_fr=grouping1_fr,grouping2_fr=grouping2_fr,ere_fr=ere_fr,infsubera_fr=infsubera_fr,period_fr=period_fr,epoch_fr=epoch_fr,age_fr=age_fr,age_min=age_min,age_max=age_max,
+structunit_fr=structunit_fr, fk_structunit=fk_structunit,regionat_fr=regionat_fr,provincegeo_fr=provincegeo_fr,
+couvertpar=couvertpar,recouvre=recouvre,couvertpar_nomunit_fr=couvertpar_nomunit_fr,recouvre_nomunit_fr=recouvre_nomunit_fr,
+lithdesc_fr=lithdesc_fr,permeab_fr=permeab_fr,consistance_fr=consistance_fr
+}}
 {| class=invisibletable style="margin: 0.5em  0em " width={{{3|500}}}px
 |rowspan="2" width={{{2|0}}}px  |
 |rowspan="2" width=105px valign="top"| {{Unités-case-couleur|{{{1|L12}}}}}
-| '''{{#sql2wiki_f:select concat('[[',abrevstrat,'|',nomunit_fr,']]') from stratunit where codestratunit="{{{1|L12}}}";}}'''
+| '''[[{{#external_value:abrevstrat2}}{{!}}{{#external_value:nomunit_fr}}]]'''
 |-
-|''{{#sql2wiki_f:select descunit_fr from stratunit where codestratunit="{{{1|L12}}}";}}''
+|''{{#external_value:descunit_fr}}''
 |}
+{{#clear_external_data:}}