sat, 21-jan-2006, 08:58

Yesterday I was searching the New Yorker DVDs and found an article by Jay McInerney. I enjoyed Bright Lights, Big City, so I went back to the search to see what else he'd written for the magazine (check out Philomena in the Dec 25, 1995 / Jan 1, 1996 issue). But I couldn't find his name in the Authors list. It turns out this is because when his name was entered into the database, he was entered as Mclnerney, Jay rather than as McInerney, Jay. The font in the viewer (as well as the New Yorker's titling font) makes an 'I' (upper-case 'eye') look just like an 'l' (lower case 'ell'), so it's hard to see the error unless you look in the database itself. (In fact, it may be hard to see in this post depending on what sans-serif font you're reading this in!)

The fix is a very simple one if you have the sqlite3 interface to the database:

> sqlite3.exe ny-sqlite-3.db
sqlite3> update Authors set Author="McInerney, Jay" where AuthorID=13374;
sqlite3> .quit

It's probably a good idea to make a copy of the ny-sqlite-3.db file before manipulating the database. On a Windows machine, this file is in C:\Program Files\New Yorker Viewer\.

I did send email to the New Yorker DVD technical support, but I don't know if this is the sort of thing they'll fix on their own or not. I hope so. Luckily, we can fix it ourselves!

tags: books  New Yorker 
Meta Photolog Archives