Toy gnus and zero tolerance

Dyslexic student expelled over toy gnu.

Homework?

Thanks to my friend Kyle for pointing this one out – Wyoming Elementary School Eliminates Homework.

Dinner

Potato-dill soup

sauté one shallot in butter, add ½ cup chopped parsely. Cook for a few minutes. Add water, 1½ cups of cubed potato and a tablespoon or two of dried dill. Boil until the potatoes are soft.

Add a teaspoon or a bit more of salt, a quarter cup of nutritional yeast.

I think it’d go great with steamed salmon. I’ll have to try that next time.

NaNoWriMo

Day 4: Part 1, part 2, part 3. 2185 words.

Day 5: zilch

Day 6: 740 words.

Time to go home and work on day 7 soon.

Well, that sucks.

Polis is down for a somewhat extended count, as it’s doing an intensive check on a huge disk.

It’s going to take about ten hours.

Food made of win

Breakfast was scrambled eggs on toast. Nothing fancy there, though the cumin I put in the eggs was fresh ground.

Lunch was spinach, chickpeas, feta, mozzarella and onions.

Dinner was fragrant lentils and rice, fragranced with pepper, coriander, cumin and cardamon. Topped with browned onions and yoghurt.

NaNoWriMo

Yes, I am nuts. But then, if I can avoid a tax audit, maybe I can do NaNo! So, based on previous storyline, here goes:

Day 1: 1063 words.

Day 2: Zilch. Work sucks sometimes.

Day 3: 2286.

1053

So I’ve got a crush on a cute and geeky girl from New Zealand. Maybe if she ends up in the US for a couple years, we’ll hang out.

I have no costume for the party tonight. I’m probably going to feel lame. Again. Oh, well. It didn’t matter terribly long last time. And this time, baileyjordan will be there! And his costume rocks.

Now, if I could just get the hotel phone server that’s been crashing off my bench.

It's happening!

He’s coming!

1051

Oh man that was a blast. I was finally around for one of the Doghouse waterfights.

My sister rocks.

Snow

It snowed for the first time this season today. It’s a bit early. Usually we get a light snow around halloween, and it’s dry for a spell after, but today we have four inches and the snow’s still falling. Town is quiet, I think everyone is surprised by the early snow. Nobody was quite ready for it.

I’m snuggled in, having done the dishes and warmed myself that way again. Made soup of herbs d’ province, sundried tomatos and cous-cous. It’s a good day to write and play the cello.

I win

Today, baileyjordan made peirogies (just the frozen kind), but he topped them with sautéed apples, onions, spinach and feta. It was made of win.

Later on, I went to the tea shop, and got to try a rather pricey green tea for free that they’d just received. It was grown in the Americas, which is unusual for tea. Kind of a fun experience.

My life is win.

1048

I just saw Monday Night in Westerbork, at the student theatre at CSU in Fort Collins. Bear was amazing. He’s put together a really excellent show. Tired now, headed back home tomorrow.

Fucking financial database

insert into auths select account_id, “authorization” from card_batch_items, customers where card_batch_id = 61 and status = ‘Completed’ and card_batch_items.customer_id = customers.id and “authorization” not in (select number from transactions where number is not null);

insert into transactions (number, date, memo) select “authorization”, ‘2007-8-25’, ‘Credit Card Charge’ from auths;

insert into transaction_items (account_id, amount, transaction_id, number) select case when alternation.i = 1 then account_id else 1552 end as account_id, case when alternation.i = 0 then -amount else amount end as amount, transactions.id as transaction_id, auths.”authorization” as number from card_batch_items, alternation, auths, transactions where card_batch_id = 60 and card_batch_items.status = ‘Completed’ and auths.”authorization” = card_batch_items.”authorization” and transactions.number = auths.”authorization”

Spot the error!

PostgreSQL:

SELECT name, "authorization" from card_batch_items 
where card_batch_id = 63 and status = 'Completed' and not "authorization" in 
	(select number from transactions where date ='2007-9-25');

Simple query, more or less. Fields like so:

card_batch_items.name varchar(25) not null,
card_batch_items.authorization varchar(25), # Will not be null if status = "Completed"
transactions.date date not null,
transactions.number integer

Simple? Not quite. If transactions.number is null for a matching row, column NOT IN (subquery) fails, because NULL = anything is NULL, and being not-true, returns nothing.