Template:Include references models cargo: Difference between revisions
No edit summary |
No edit summary |
||
Line 7: | Line 7: | ||
* {{ | * {{ | ||
#arraydefine: val | {{#arrayindex:refs | {{#var:i}} }} | ; | #arraydefine: val | {{#arrayindex:refs | {{#var:i}} }} | ; | ||
}} {{#ifeq: {{#cargo_query:tables= RefsInt1|where = _pageName = '{{#arrayindex: val | 0}}'|default=|fields= PublicationWhatKindOf|format=template|template=Test7a}}|a module overview describing a module| empty1 results|{{#cargo_query:tables=RefsExt|where = _pageName = '{{#arrayindex: val | 0}}'|default=|fields= Lastname, Firstname|format=template|template=Test4a}}{{#cargo_query:tables=RefsExt2|where = _pageName = '{{#arrayindex: val | 0}}'|default=|fields= ItemType, Title , PublicationTitle, Booktitle, JournalAbbreviation, Volume, Issue, Url, DOI, Pagenumbers, Publicationdate, AbstractNote, Language, LibraryCatalog, AccessDate |format=template|template=Test5a}}{{#cargo_query:tables=RefsInt1|where = _pageName = '{{#arrayindex: val | 0}}'|default=|fields= PublicationClusterID, PublicationWhatKindOf, PublicationNrofModels, PublicationHPCCYesno, PublicationMultipleModelsCargo, PublicationHPCCprojectCargo, PublicationAnimationsCargo|format=template|template=Test6a}} }} | }} {{#cargo_query:tables= RefsInt1|where = _pageName = '{{#arrayindex: val | 0}}'|default=|fields= PublicationWhatKindOf|format=template|template=Test7a}} {{#ifeq:{{#cargo_query:tables= RefsInt1|where = _pageName = '{{#arrayindex: val | 0}}'|default=|fields= PublicationWhatKindOf|format=template|template=Test7a}}|a module overview describing a module| empty1 results| {{#cargo_query:tables=RefsExt|where = _pageName = '{{#arrayindex: val | 0}}'|default=|fields= Lastname, Firstname|format=template|template=Test4a}}{{#cargo_query:tables=RefsExt2|where = _pageName = '{{#arrayindex: val | 0}}'|default=|fields= ItemType, Title , PublicationTitle, Booktitle, JournalAbbreviation, Volume, Issue, Url, DOI, Pagenumbers, Publicationdate, AbstractNote, Language, LibraryCatalog, AccessDate |format=template|template=Test5a}}{{#cargo_query:tables=RefsInt1|where = _pageName = '{{#arrayindex: val | 0}}'|default=|fields= PublicationClusterID, PublicationWhatKindOf, PublicationNrofModels, PublicationHPCCYesno, PublicationMultipleModelsCargo, PublicationHPCCprojectCargo, PublicationAnimationsCargo|format=template|template=Test6a}} }} | ||
}} | }} |
Revision as of 15:56, 5 May 2017
- 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 'PublicationMultipleModelsCargo' in 'where clause'\x0AFunction: CargoSQLQuery::ru' at line 1
Function: CargoSQLQuery::run Query: SELECT `mw_cargo__RefsInt1`.`_pageID` AS `cargo_backlink_page_id_RefsInt1`,`PublicationWhatKindOf` AS `PublicationWhatKindOf` FROM `mw_cargo__RefsInt1` WHERE _pageName = '<div class="error">Error 1054: Unknown column 'PublicationMultipleModelsCargo' in 'where clause' Function: CargoSQLQuery::run Query: SELECT `mw_cargo__RefsInt1`.`_pageID` AS `cargo_backlink_page_id_RefsInt1`' ORDER BY `mw_cargo__RefsInt1`.`_pageID`,`PublicationWhatKindOf` LIMIT 1000
Function: CargoSQLQuery::run Query: SELECT `mw_cargo__RefsExt`.`_pageID` AS `cargo_backlink_page_id_RefsExt`,`Lastname` AS `Lastname`,`Firstname` AS `Firstname` FROM `mw_cargo__RefsExt` WHERE _pageName = '<div class="error">Error 1054: Unknown column 'PublicationMultipleModelsCargo' in 'where clause' Function: CargoSQLQuery::run Query: SELECT `mw_cargo__RefsInt1`.`_pageID` AS `cargo_backlink_page_id_RefsInt1`' ORDER BY `mw_cargo__RefsExt`.`_pageID`,`Lastname`,`Firstname` LIMIT 1000
- 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 'Include references models cargo' ORDER BY `mw_cargo__RefsInt1`.`_pageID`' ORDE' at line 1
Function: CargoSQLQuery::run Query: SELECT `mw_cargo__RefsInt1`.`_pageID` AS `cargo_backlink_page_id_RefsInt1`,`PublicationWhatKindOf` AS `PublicationWhatKindOf` FROM `mw_cargo__RefsInt1` WHERE _pageName = '`_pageName` AS `_pageName` FROM `mw_cargo__RefsInt1` WHERE PublicationMultipleModelsCargo = 'Include references models cargo' ORDER BY `mw_cargo__RefsInt1`.`_pageID`' ORDER BY `mw_cargo__RefsInt1`.`_pageID`,`PublicationWhatKindOf` LIMIT 1000
Function: CargoSQLQuery::run Query: SELECT `mw_cargo__RefsExt`.`_pageID` AS `cargo_backlink_page_id_RefsExt`,`Lastname` AS `Lastname`,`Firstname` AS `Firstname` FROM `mw_cargo__RefsExt` WHERE _pageName = '`_pageName` AS `_pageName` FROM `mw_cargo__RefsInt1` WHERE PublicationMultipleModelsCargo = 'Include references models cargo' ORDER BY `mw_cargo__RefsInt1`.`_pageID`' ORDER BY `mw_cargo__RefsExt`.`_pageID`,`Lastname`,`Firstname` LIMIT 1000