Just a note to self. Vague unformed ideas, and possible plans. Ignore me.
An interesting anti-piracy experiment, and Soderbergh has some solid and sensible points about the need for better rights/copyright law.
This entry was originally published at my workblog.
I was at the whisky society with burge tonight. She drank this whisky. It was fucking fantastic, and I wanted some. I especially wanted some for myself, because I think it would have gone fucking brilliantly with a good cigar.
They’re sold out.
I’m going to crawl into a corner and cry, now.
(Anyone fancy drinking a few good whiskies in the next week or two?)
Here’s one for the PHP webnerds out there:
PHP/SQL7. At the start of every script, I include db.php which contains this:
$db = mssql_connect(‘devbox’,’foo’,’bar’);
mssql_select_db(‘[devsitedb]’, $db) or die (“Couldn’t open database connection”);
And then I pass that connection into the various classes and functions on the site. Fine and dandy.
However, in the course of one fo the scripts for this site, I need to hook into a second database temporarily, so I do this at the appropriate point:
$second_db = mssql_connect(‘devbox’,’jim’,’bob’);
mssql_select_db(‘[anothersitedb]’, $second_db) or die (“Couldn’t open second database connection”);
Then do what I need to with that connection and close it with mssql_close($second_db);
Here’s the problem, though: despite the fact that the two connections are clearly different, the second one is overwriting the first, so that when I come back to doing things with the first connection, it now can’t find any of the stored procedures i needs. This is true at any point after $second_db is opened, and it make no difference whether or not I close $second_db. The conenction is just being over-written.
At the point of opening, print_r($db) returns “Resource id #2”. And that holds true for the second connection as well – print_r($second_db) also returns “Resource id #2”.
mssql.max_links is set to -1, so there should be no problem with the number of connections that I’m making…
Obviously, I would like it if this didn’t happen, and $second_db become “Resource id #3”, thus allowing me to juggle the two connections as I need to.
Anyone out there had similar problems, or able to spot what I’m missing?
Well, it’s December, so obviously, it’s time for the heavy drinking again. Spent the first part of Thursday night at Albertine in Sheperd’s Bush. Bit full of BBC types, but after three quarters of a bottle of Australian red (the name of which escapes me, which is annoying, because I’d happily buy it again) I cared a lot less. Might try and get back there – the wine list looked interesting, and the food sounded like it’d go well with the wine…
Quiet night in Friday night, and then out for drinks with davebushe, daveman23 and seanazz last night, which were just what the doctor ordered, I think. Sadly, the slight hangover combined with the first trip to the gym in a couple of weeks has left me more or less unable to move.
I rewatched the first episode of The Prisoner this morning. It’s dated very strangely, that show – it’s unmistakably of a certain era, but because of the very stilted and stylised atmosphere in the village, it gets away with it surprisingly well, and it sort of feels like the sixites/seventies decor is just another part of the strangeness of the setting, rather than a sign of aging. Why do I suspect that the upcoming remake won’t be half so clever?