SELECT * FROM contacts WHERE type = 'Executive' order by sort
SELECT * FROM contacts WHERE type = 'Scheduler' order by sort
SELECT * FROM contacts WHERE type = 'Statistician' order by sort
SELECT * FROM contacts
WHERE type != 'Executive'
AND type != 'Scheduler'
AND type != 'Statistician'
AND league = 'peewee'
GROUP BY position
ORDER BY sort
SELECT * FROM contacts
WHERE type != 'Executive'
AND type != 'Scheduler'
AND type != 'Statistician'
AND league = 'midget'
GROUP BY position
ORDER BY sort
SELECT * FROM contacts
WHERE type != 'Executive'
AND type != 'Scheduler'
AND type != 'Statistician'
AND league = 'bantam'
GROUP BY position
ORDER BY sort
EAST CENTRAL ALBERTA FEMALE HOCKEY LEAGUE
#year(now())# CONTACT LIST
ECAFHL Executive
#position#
#name#
#address#
Phone: #phone#
Cell: #cell#
Fax: #fax#
Email: #email#
|
ECAFHL Divisional Schedulers
#league#
#name#
#address#
Phone: #phone#
Cell: #cell#
Fax: #fax#
Email: #email#
|
HOME TEAM: All ECAFHL game sheets MUST be faxed to your divisional statistician by Monday noon. If there is a Referee Write-up or a Game Misconduct in the final ten minutes you must ensure a phone report is made to Dave ASAP and fax the game sheet to both Dave and your statistician ASAP following game completion.
INDIVIDUAL PLAYER STATS: Coaches / Managers are responsible for keeping accurate record of your teams individual player stats.
ECAFHL Divisional Statisticians
#league#
#name#
#address#
Phone: #phone#
Cell: #cell#
Fax: #fax#
Email: #email#
|
The ECAFHL schedules are drawn from the ice times and draws given by your team representatives. It is your responsibility to confer with your association to ensure these slots are available to your team as per schedule. If changes are required, ensure the home team fills out the Game Change Sheets with the opposing team well in advance.
Peewee Division
SELECT * FROM contacts WHERE position = '#qGetPeewee.position#' AND league = 'peewee' ORDER BY sort
|
#position#
#type#: #name#
Phone: #phone#
Cell: #cell#
Fax: #fax#
Email: #email#
|
Midget Division
SELECT * FROM contacts WHERE position = '#qGetMidget.position#' AND league = 'midget' ORDER BY sort
|
#position#
#type#: #name#
Phone: #phone#
Cell: #cell#
Fax: #fax#
Email: #email#
|
Bantam Division
SELECT * FROM contacts WHERE position = '#qGetBantam.position#' AND league = 'bantam' ORDER BY sort
|
#position#
#type#: #name#
Phone: #phone#
Cell: #cell#
Fax: #fax#
Email: #email#
|