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}} }}...")
 
(Replaced content with "{{OBUExcoYearMembers}}")
Tag: Replaced
 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{#vardefine:Year|{{#expr: {{#sub:{{PAGENAME}}|-4|4}} }} }}
{{OBUExcoYearMembers}}
{{#vardefine:Len|{{#len:{{PAGENAME}}}}}}
 
{{#vardefine:Group|{{#expr: {{#sub:{{PAGENAME}}|0|{{{{#var:Len}}-10}} }} }} }}
 
{{#get_db_data:
|server=drck-db
|from=wikiobuyearsexco
|where=(OBUName='{{Group}}') and (Year='{{Year}}')
|order by=DisplayOrder ASC
|data=OBUPosition=OBUPosition, Title=Title,Initials=Initials,FirstName=FirstName, LastName=LastName
}}
 
{| class="wikitable"
! ExCo Position
! Name
! Photo
{{#for_external_table:<nowiki/>
{{!}}-
{{!}} {{{OBUPosition}}}
{{!}} {{{Title}}} {{{Initials}}}{{{FirstName}}}{{{LastName}}
{{!}} {{{Photo}}}
}}
}}
|}
*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}}}
}}
|}

Latest revision as of 09:54, 4 June 2024


The query SELECT OBUPosition,Title,Initials,FirstName,LastName,Image,Year FROM `wikiobuyearsexco` WHERE OBUName='Old Rajans 79/80 Group' and Year='1994' is invalid (Error 1146: Table 'drck_admin.wikiobuyearsexco' doesn't exist Function: EDConnectorRdbms::fetch Query: SELECT OBUPosition,Title,Initials,FirstName,LastName,Image,Year FROM `wikiobuyearsexco` WHERE OBUName='Old Rajans 79/80 Group' and Year='1994' ).

ExCo Position Name Photo
Retrieved from "https://dharmaraja.net/index.php?title=Old_Rajans_79/80_Group:ExCo:1994&oldid=780"