Modèle:Recherche : Différence entre versions

(Page créée avec « {{#cargo_query:table=Sequences |field=_pageName,titre,dateDebut,dateFin,apercu,idSupport,localisation |where=titre HOLDS {{{titre}}} and dateDebut > {{{dateDebut}}} |group... »)
 
Ligne 1 : Ligne 1 :
 
{{#cargo_query:table=Sequences
 
{{#cargo_query:table=Sequences
 
|field=_pageName,titre,dateDebut,dateFin,apercu,idSupport,localisation
 
|field=_pageName,titre,dateDebut,dateFin,apercu,idSupport,localisation
|where=titre HOLDS {{{titre}}} and dateDebut > {{{dateDebut}}}
+
|where=titre LIKE %{{{titre|}}}% and dateDebut > {{{dateDebut|1800}}}
 
|group by=_pageName
 
|group by=_pageName
 
}}
 
}}

Version du 27 septembre 2018 à 11:23

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `_pageName` AS `_pageName` FROM `A_cargo__Sequences` WHERE titre LIKE %% and dateDebut > 1800 GROUP BY `_pageName` ORDER BY `_pageName` LIMIT 100 Function: CargoSQLQuery::run 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 '%% and dateDebut > 1800 GROUP BY `_pageName` ORDER BY `_pageName` LIMIT 100' at line 1 (bdd10.u-strasbg.fr)