Canadian Mysteries

  • Front Page
  • Contact
  • Log in
  • « de-orphaning links pages on Franklin site
  • fix broken links in mysteryquest »

Request for teacher locations

Posted by mholmes on 30 Mar 2017 in Activity log

JL called asking for a list of the Canadian cities from which teachers have registered. I pulled the XML version of the tg_users table from the server and ran this:

let $tables := for $t in //table[column[@name='mailingCountry'][normalize-space(upper-case(.)) = 'CANADA']] return $t
let $addresses := for $t in $tables return normalize-space(upper-case(concat($t/column[@name='mailingCity'], ', ', $t/column[@name='mailingState'])))
let $uniqueAddresses := distinct-values($addresses)
let $orderedAddresses := for $u in $uniqueAddresses order by $u return $u
return string-join($orderedAddresses, '
')

to get a quick-and-dirty list of city, province. I had to search-and-replace some ugly character encoding issues -- the db thinks it has UTF-8 but the data coming in has obviously been 8859-1. Sent the results to JL.

This entry was posted by Martin and filed under Activity log.

Canadian Mysteries

The Canadian Mysteries site consists of a production site containing 12 mysteries, a containing shell and 30 mysteryquests; and a database-driven development site. HCMC took over tech support in summer 08. This blog documents work done on the site from Sept 08. Earlier work is documented in the depts blog in posts prepended with CanMys
  • Home
  • Recently
  • Archives
  • Categories
  • Latest comments

Search

Categories

  • All
  • Activity log
  • Announcements
  • Tasks

XML Feeds

  • RSS 2.0: Posts
  • Atom: Posts
What is RSS?

Recent Posts

  • Added Sarah Taekema as new Mysteries Admin
  • fix urlencode problem on photo.php pages
  • Batch process images
  • moved learning materials pages
  • de-orphaning links pages on Franklin site
  • Request for teacher locations
  • fix broken links in mysteryquest
  • change backend database pointers
  • landing pages for parks canada
  • Franklin Google search styled

Sidebar 2

This is the "Sidebar 2" container. You can place any widget you like in here. In the evo toolbar at the top of this page, select "Customize", then "Blog Widgets".

This collection ©2025 by admin • Help • CMS engine