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 | |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 | ||
}} | }} | ||
| Line 17: | Line 17: | ||
{{!}} {{{AffilatedFrom}}} | {{!}} {{{AffilatedFrom}}} | ||
{{!}} {{{AffilationTo}}} | {{!}} {{{AffilationTo}}} | ||
{{!}} {{{ExternalPage}}} | |||
{{!}} {{{Photo}}} | {{!}} {{{Photo}}} | ||
}} | }} | ||
|} | |} | ||
Revision as of 20:24, 7 December 2023
The query SELECT SNo,LastName,Initials,Photo,FirstName,ID,Title,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,AffilatedFrom,AffilationTo,ActiveAffiliation,ExternalPage FROM `wikiaffilations` WHERE (AffiliationGroup='ListAffiliations') ORDER BY AffilatedFrom,LastName ASC ).
| Name | From | To | Photo |
|---|