Old Rajans 79/80 Group:ExCo:1994: Difference between revisions

From Dharmaraja College Archives
Jump to navigation Jump to search
(Created page with "{{#vardefine:Year|{{#expr: {{#sub:{{PAGENAME}}|-4|4}} }} }} {{#vardefine:Len|{{#len:{{PAGENAME}}}}}} {{#vardefine:Group|{{#expr: {{#sub:{{PAGENAME}}|0|{{{{#var:Len}}-10}} }}...")
 
No edit summary
Line 25: Line 25:
|}
|}
*use template <nowiki> {{Teams}}</nowiki> for these pages
*use template <nowiki> {{Teams}}</nowiki> for these pages
{{#vardefine:Year|{{#expr: {{#sub:{{PAGENAME}}|-4|4}} }} }}
{{#vardefine:From|'{{#var:Year}}/01/01'}}
{{#vardefine:To|'{{#var:Year}}/12/31'}}
{{#get_db_data:
|server=drck-db
|from=wikiaffilations
|where=(AffiliationGroupID='1') and (AffilatedFrom>={{#var:From}} ) and (AffilatedFrom<={{#var:To}})
|order by=LastName ASC
|data=SNo=SNo,LastName=LastName,Initials=Initials, Photo=Photo,FirstName=FirstName, ID=ID, Title=Title, Photo=Photo, AffilatedFrom=AffilatedFrom,AffilationTo=AffilationTo
}}
{| class="wikitable"
! Name
! Admitted On
! Photo{{#for_external_table:<nowiki/>
{{!}}-
{{!}} [[{{{LastName}}} {{{Initials}}} (SNo:{{{SNo}}})|{{{Title}}} {{{LastName}}} {{{Initials}}} ( {{{FirstName}}})]]
{{!}} {{{AffilatedFrom}}}
{{!}} {{{Photo}}}
}}
|}

Revision as of 09:07, 4 June 2024



The query SELECT OBUPosition,Title,Initials,FirstName,LastName FROM `wikiobuyearsexco` WHERE (OBUName='Template:Group') and (Year='Template:Year') ORDER BY DisplayOrder ASC is invalid (Error 1146: Table 'drck_admin.wikiobuyearsexco' doesn't exist Function: EDConnectorRdbms::fetch Query: SELECT OBUPosition,Title,Initials,FirstName,LastName FROM `wikiobuyearsexco` WHERE (OBUName='Template:Group') and (Year='Template:Year') ORDER BY DisplayOrder ASC ).

ExCo Position Name Photo

}}

  • use template {{Teams}} for these pages
Retrieved from "https://dharmaraja.net/index.php?title=Old_Rajans_79/80_Group:ExCo:1994&oldid=774"