"Principle" for "principal". Been there for years. Sad.
Changed intro page to "Background" and added new info, fixed venue page info, validated and fixed unescaped ampersands. I think this is probably fine now. Waiting for final approval before moving it to www.
Bit of feedback and a couple of fixes on the Contact us page. Nearly ready to copy to www.
I've pushed all the existing content I've been given into the site. I can kick it out to the people involved for review tomorrow. Pruned out non-city-related images as well.
JS-R has brought a new website project which will be done using time taken from the Properties db project. It's for a series of talks to take place downtown, and the idea is to use the BC Studies conference site design for it, with minimal changes, so it should be done very quickly. Made a start by copying over all the old content, deleting a lot of stuff, changing metadata and includes, and pushing it up into an account in
lancenrd. I'll need to review all the images -- there's a lot of stuff there that's not needed, and many images are not "urban" so don't suit the site, but there should be enough decoration that is on-topic.
GR in GRS asked for the addition of a set of alphabetic links to aid in navigation of the lengthy list of journals. This proved to be quite tricky, because the list itself was being written out by the RssFeedReader code that was originally adapted for use with the UVic Events Calendar feed, which itself is highly idiosyncratic; rather than mess directly with that, and risk breaking the events page, I limited my changes there to making a couple of the class's variables public, so that I could take over the sorting and output of the journal list in the
periodicals.php page. That's now been done, and there's a working alphabetical links list. There's one more outstanding feature request for this component of the site -- a smaller list of recent changes -- but it's not really clear what constitutes a recent change (new issue of journal, or change to journal data), so I'm waiting for clarification on that from GR.
In the process of validating, I found some errors in the GRS menu that must have been affecting all the pages for a while. There were missing spaces between the end of the style attribute and the beginning of the href attribute in many of the menu items. Fixed that.
Transferred two updated pages to the main site.
Rewriting Subselects That Select Non-Matching (Missing) Values
Another common type of subselect query searches for values in one table that are not present in another table. As we've seen before, the "which values are not present" type of problem is a clue that a LEFT JOIN may be helpful. The following is a query with a subselect that tests for students who are not listed in the absence table (it finds those students with perfect attendance):
SELECT * FROM student
WHERE student_id NOT IN (SELECT student_id FROM absence);
This query can be rewritten using a LEFT JOIN as follows:
FROM student LEFT JOIN absence ON student.student_id = absence.student_id
WHERE absence.student_id IS NULL;
In general terms, the subselect query form is as follows:
SELECT * FROM table1
WHERE column1 NOT IN (SELECT column2 FROM table2);
A query having that form can be rewritten like this:
FROM table1 LEFT JOIN table2 ON table1.column1 = table2.column2
WHERE table2.column2 IS NULL;
This assumes that table2.column2 is declared as NOT NULL.