Test-abc: Difference between revisions
From CSDMS
No edit summary |
No edit summary |
||
| Line 10: | Line 10: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=RefsExt | tables=RefsExt | ||
|fields=_pageName=Page,_ID=ID,DOIentry,Firstname,Lastname,ItemType,Title,PublicationTitle,Booktitle,JournalAbbreviation,Volume,Issue,ISSN,Url,DOI,Pagenumbers,Publicationdate,Language,LibraryCatalog,AccessDate | |fields=_pageName=Page,_ID=ID,DOIentry,Firstname,Lastname | ||
|where=Firstname HOLDS NOT '' | |||
|format=ul | |||
}} | |||
{{#cargo_query: | |||
tables=RefsExt | |||
|fields=_pageName=Page,_ID=ID,DOIentry,ItemType,Title,PublicationTitle,Booktitle,JournalAbbreviation,Volume,Issue,ISSN,Url,DOI,Pagenumbers,Publicationdate,Language,LibraryCatalog,AccessDate | |||
|where=Firstname HOLDS NOT '' | |where=Firstname HOLDS NOT '' | ||
|format=ul | |format=ul | ||
}} | }} | ||
Revision as of 13:12, 2 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 'HOLDS NOT ORDER BY `mw_cargo__RefsExt`.`_pageID`,`_pageName`,`_ID`,`DOIentry' at line 1
Function: CargoSQLQuery::run Query: SELECT `mw_cargo__RefsExt`.`_pageID` AS `cargo_backlink_page_id_RefsExt`,`_pageName` AS `Page`,`_ID` AS `ID`,`DOIentry` AS `DOIentry`,`Firstname` AS `Firstname`,`Lastname` AS `Lastname` FROM `mw_cargo__RefsExt` WHERE Firstname HOLDS NOT ORDER BY `mw_cargo__RefsExt`.`_pageID`,`_pageName`,`_ID`,`DOIentry`,`Firstname` LIMIT 1000
Error: No field named "ItemType" found for any of the specified database tables.
