Sam's notebook

Preventing duplicate rows in a tabular HTML form July 12th, 2011, 3PM


I am working on a bespoke issue-tracking system at the moment (not for code issue-tracking, in case anyone thinks we’re cloning Redmine; although there certainly are overlaps…) in which each issue has a list of personnel, each of whom have a role on the issue. The task at hand is to prevent people selecting the […]

[No comments] [Keywords: , , , , , , , , ] [Permanent link]

West 86th - Paperwork Explosion May 21st, 2011, 12PM


“Machines should work, people should think.” The message repeats itself several times; it’s the core of the film’s techno-utopian vision. We can imagine IBM executives and lawyers and public relations agents sitting across a table from Jim Henson telling him to make sure he includes these lines in his film. What if, following William Empson’s […]

[No comments] [Keywords: , , , , , , ] [Permanent link]

Finding all date ranges (which may be open-ended) that overlap with a given range May 17th, 2011, 11AM


Given a database table listing events and their date ranges: events { id, start_date, end_date, … }, where either or both of the dates can be null, how is one to find all of the events that fall within (even partially) a given date range? (This is pretty much what Kieran Benton asked on Stack […]

[No comments] [Keywords: , , , , , , , ] [Permanent link]