Template:Org Program list: Difference between revisions
(Created page with "{{#cargo_query: tables=Program |fields=Program.ProgramName, Program.OrgSponsor, Program.ProgramStart, Program.InitialFunding, Program.Duration |where=Program.Diocese LIKE "%{{{Org}}}%" |format=table }}<noinclude>{{Doc}}</noinclude>") |
(remove items until new table created) |
||
| Line 1: | Line 1: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Program | tables=Program | ||
|fields=Program.ProgramName, Program.OrgSponsor | |fields=Program.ProgramName, Program.OrgSponsor | ||
|where=Program.Diocese LIKE "%{{{Org}}}%" | |where=Program.Diocese LIKE "%{{{Org}}}%" | ||
|format=table | |format=table | ||
}}<noinclude>{{Doc}}</noinclude> | }}<noinclude>{{Doc}}</noinclude> | ||
Revision as of 22:28, 6 February 2025
Error 1054: Unknown column 'cargo__Program.Diocese' in 'where clause'
Function: CargoSQLQuery::run Query: SELECT `cargo__Program`.`_pageID` AS `cargo_backlink_page_id_Program`,`cargo__Program`.`ProgramName` AS `ProgramName`,`cargo__Program`.`OrgSponsor` AS `OrgSponsor` FROM `cargo__Program` WHERE `cargo__Program`.`Diocese` LIKE "%{{{Org}}}%" ORDER BY `cargo__Program`.`_pageID`,`cargo__Program`.`ProgramName`,`cargo__Program`.`OrgSponsor` LIMIT 100
Template documentation