Template:ListAffiliations: Difference between revisions
Jump to navigation
Jump to search
Kamalanath (talk | contribs) No edit summary |
Kamalanath (talk | contribs) No edit summary |
||
| Line 5: | Line 5: | ||
|where=(AffiliationGroup='{{PAGENAME}}') | |where=(AffiliationGroup='{{PAGENAME}}') | ||
|order by=AffilatedFrom,LastName ASC | |order by=AffilatedFrom,LastName ASC | ||
|data=SNo=SNo,LastName=LastName,Initials=Initials, Photo=Photo,FirstName=FirstName, ID=ID, Title=Title, Photo=Photo, AffilatedFrom=AffilatedFrom,AffilationTo=AffilationTo, ActiveAffiliation=ActiveAffiliation, ExternalPage=ExternalPage | |data=SNo=SNo,LastName=LastName,Initials=Initials, Photo=Photo,FirstName=FirstName, ID=ID, Title=Title, Photo=Photo, PhotoTh=PhotoTh,AffilatedFrom=AffilatedFrom,AffilationTo=AffilationTo, ActiveAffiliation=ActiveAffiliation, ExternalPage=ExternalPage | ||
}} | }} | ||
Revision as of 14:22, 21 April 2024
The query SELECT SNo,LastName,Initials,Photo,FirstName,ID,Title,PhotoTh,AffilatedFrom,AffilationTo,ActiveAffiliation,ExternalPage FROM `wikiaffilations` WHERE (AffiliationGroup='ListAffiliations') ORDER BY AffilatedFrom,LastName ASC is invalid (Error 1054: Unknown column 'ExternalPage' in 'field list' Function: EDConnectorRdbms::fetch Query: SELECT SNo,LastName,Initials,Photo,FirstName,ID,Title,PhotoTh,AffilatedFrom,AffilationTo,ActiveAffiliation,ExternalPage FROM `wikiaffilations` WHERE (AffiliationGroup='ListAffiliations') ORDER BY AffilatedFrom,LastName ASC ).
| Name | From | To | ExternalPage | Photo |
|---|