« Modèle:DBRecensementsQuery » : différence entre les versions
Aucun résumé des modifications |
Aucun résumé des modifications |
||
| Ligne 6 : | Ligne 6 : | ||
|data= COUNT(*) as occu,nom | |data= COUNT(*) as occu,nom | ||
}} | }} | ||
{{#for_external_table:<nowiki/> | {|width=800px | ||
|<ol> | |||
{| class="wikitable sortable" | |||
! Numéro | |||
! Page | |||
! Feu | |||
! Nom ~ Profession | |||
! Village (Parcelle) | |||
! Sexe | |||
! Actif | |||
! Lien ~ Rattachement | |||
! Age | |||
! Commentaire {{#for_external_table:<nowiki/> | |||
{{!}}- | |||
{{!}}{{{occu}}} | |||
{{!}}{{{page}}} | |||
{{!}}{{{menage}}} | |||
{{!}}{{{pren}}} {{{nom}}} ~ {{{profession}}} | |||
{{!}}{{{village}}} ({{{parcelle}}}) | |||
{{!}}{{{sexe}}} | |||
{{!}}{{{actif}}} | |||
{{!}}{{{lien}}} ~ {{{rattachement}}} | |||
{{!}}{{{age}}} | |||
{{!}}{{{comment}}} | |||
}} | |||
|} | |||
</ol> | |||
|} | |||
{{#get_db_data: | {{#get_db_data: | ||
db=Recensements | db=Recensements | ||
Version du 3 décembre 2023 à 14:22
La requête SELECT count(*) as occu,nom FROM `recensements` WHERE {{{whereclause}}} ORDER BY page,id ASC n’est pas valide (Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Modèle:Whereclause} ORDER BY page,id ASC' at line 1 Function: EDConnectorRdbms::fetch Query: SELECT count(*) as occu,nom FROM `recensements` WHERE {{{whereclause}}} ORDER BY page,id ASC ).
|
La requête SELECT annee,page,id,menage,nom,pren,profession,village,parcelle,sexe,actif,lien,rattachement,age,comment FROM `recensements` WHERE {{{whereclause}}} ORDER BY page,id ASC n’est pas valide (Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Modèle:Whereclause} ORDER BY page,id ASC' at line 1 Function: EDConnectorRdbms::fetch Query: SELECT annee,page,id,menage,nom,pren,profession,village,parcelle,sexe,actif,lien,rattachement,age,comment FROM `recensements` WHERE {{{whereclause}}} ORDER BY page,id ASC ).
|