Template:ListAffiliations: Difference between revisions
Jump to navigation
Jump to search
Kamalanath (talk | contribs) No edit summary |
Kamalanath (talk | contribs) No edit summary |
||
| Line 4: | Line 4: | ||
|from=wikiaffilations | |from=wikiaffilations | ||
|where=(AffiliationGroup='{{PAGENAME}}') | |where=(AffiliationGroup='{{PAGENAME}}') | ||
|order by= | |order by=LastName ASC | ||
|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 | |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 18:23, 26 April 2024
The query SELECT SNo,LastName,Initials,Photo,FirstName,ID,Title,PhotoTh,AffilatedFrom,AffilationTo,ActiveAffiliation,ExternalPage FROM `wikiaffilations` WHERE (AffiliationGroup='ListAffiliations') ORDER BY 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 LastName ASC ).
| Name | From | To | ExternalPage | Photo |
|---|