« Modèle:DBRecensementsQuery » : différence entre les versions
Aucun résumé des modifications |
Aucun résumé des modifications |
||
| Ligne 9 : | Ligne 9 : | ||
|<ol> | |<ol> | ||
{| class="wikitable sortable" | {| class="wikitable sortable" | ||
{{#for_external_table:<nowiki/> | |||
{{!}}- | {{!}}- | ||
{{!}}{{{occu}}} | {{!}}{{{occu}}} | ||
Version du 3 décembre 2023 à 14:23
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 ).
|