Entries this day: Airplane_Day Billing Fast_reaction Lookin'_for_free_internets Work

Airplane Day

10:20am JST Monday 15 December 2008 (day 14145)

NIST has acknowledged that WTC 7 came down at freefall speed (for at least part of its demise). I dunno if this will ultimately be a step in the direction of 911 truth or just a loose change in their claims of extraordinary events, but I hope we'll have some convictions soon.

Billing

4:54pm JST Monday 15 December 2008 (day 14145)

Though it's taken a bit longer than I thought it might today, my code in fact was pretty solid, and just needed several tweaks in some areas. I needed to add ORDER BY in a place or two, and add a query when ORDER BY couldn't be added (at least not with my mySQL skillset).

Fast reaction

6:36pm JST Monday 15 December 2008 (day 14145)

Though I hate every other decision he's made, George Bush impressed me with his quick duck and chilled composure when the dude threw his shoes at him.

Lookin' for free internets

9:57pm JST Monday 15 December 2008 (day 14145)

I've been wandering around Shibuya station in search of free wireless so Fred can email me when he gets here. Instead of free internets, I found some pay phones. I also found a wireless signal called GoogleGuest which appeared unencrypted, but didn't seem usable once I connected. I may contact my "friend" who works at Google to see if she can tell me how to connect to that signal. If I can remember her name, that is.

If I can't remember her name nor otherwise work out a connection for Fred, I'll suggest the pay phones. They're pretty close to both Yamanote Line and Tokyu Toyoko Line, and they're inside, next to an area featuring foodages.

10:17pm JST Monday 15 December 2008 (day 14145)

Ah. I know! I have in my wallet a phone card that can be used for pay phones in Japan. I'll tape that card under the phone in question so Fred can use it when he gets to Shibuya! That will be like a personalized version of geocaching or me-bro stashing or something. I've wanted to place secret notes in the Eiffel Tower so I could tell my Paris-trip-planning friend to find the note. Not sure what happened with that, but I can vaguely remember looking for a place to stash such a note (behind one of the pictures on the way up the stairs was my best idea). Anyway, I'm pretty sure this will work so Fred can call me. And it'll be fun!

Work

10:03pm JST Monday 15 December 2008 (day 14145)

Worked pretty solidly today, though I took a break around 6pm to watch The (last) Daily Show (of 2008) (funny), (the equally last) Colbert Report (まま), and "The List" episode (last of Season 11) of Southpark (pretty funny).

The code pretty much gets all the right numbers, but doesn't yet put them all in the right order. I semi-sorta know what's happening, but I don't know exactly where it's happening (or maybe I do), and I'm not sure how to fix it.

Oh. I just figured out a way to fix it.

Basically there were two sets of sort orders, and when the items were getting merged, one of the sets was having its sort_order field re-set correctly, but the other was not.

However, they were all being inserted into the table in the correct order, so once they are all in place, I can just set the sort_order = the (autoincrementing) id. Perfect. The sort orders won't start from 0 nor 1, but they'll be in order.

hahaha it may be the case that I made the sort_order a smallint or something. That'll teach me to try to save space! I'ma make it an unsigned INT!