KBD

Keith Devens .com

Friday, July 4, 2008 Flag waving
Never ascribe to malice, that which can be explained by incompetence. – Napoleon Bonaparte

Archive: March 05, 2004

← March 04, 2004March 08, 2004 →

Daily link icon Friday, March 5, 2004

Using continuations for web development

I have to learn more about using continuations for web development. Via Erik

Tony Blair is the man

Tony Blair is the man

SQL question

Say I have some tables such as (to be really generic):

Objects
Object_Id
more fields...

and

Properties
Object_Id
Property_Name

So, every "object" can have multiple "properties". Now, it's really easy to say "give me all the objects which have ANY of these properties" with something like "SELECT Objects.* FROM Objects INNER JOIN Properties USING(Object_Id) WHERE Property_Name IN([list of properties])"

But how can you easily get the set of objects which have ALL of the properties in the [list of properties]? You could say something like:

"SELECT * FROM Objects WHERE Object_Id IN(
INTERSECT(
(SELECT Object_Id FROM Properties WHERE Property_Name = list[0]),
(SELECT Object_Id FROM Properties WHERE Property_Name = list[1]),
(SELECT Object_Id FROM Properties WHERE Property_Name = list[2]),
etc.
)"

But that's a mess, and doesn't happen to be available to me anyway since I'm using MySQL.

Anyone know the right way to do this?

Concealed carry

Clayton Cramer relays some interesting statistics in this year's report of concealed carry license issues and issuees from the state of Minnesota.

North Korea wants Kerry to be president

North Korea warms to Kerry presidency bid.

What have I said time and time again? That all the dictators and terrorists in the world want a Democratic win this year.

In the past few weeks, speeches by the Massachusetts senator have been broadcast on Radio Pyongyang and reported in glowing terms by the Korea Central News Agency (KCNA), the official mouthpiece of Mr Kim's communist regime. ... Pyongyang seems to hope victory for the Democratic candidate on November 2 would lead to a softening in US policy towards the country's nuclear weapons programme.

But both Mr Kerry and Mr Bush are committed to North Korean disarmament. Mr Kerry, however, would renew bilateral negotiations between Washington and Pyongyang, while Mr Bush has sought to manage the conversation with North Korea through multilateral talks. Mr Kerry has also been more forthright about setting out the economic rewards for North Korea if it disarms.

First Iran, now North Korea.

Update: publius at Wunderkinder just reminded me of this Lileks article I'd linked to earlier.

Update: Well, now I know not to trust the Financial Times to keep their archives around. This page is now behind a "subscriber only" wall. I'm glad I quoted some of it.

← March 04, 2004March 08, 2004 →
July 2008
SunMonTueWedThuFriSat
 12345
6789101112
13141516171819
20212223242526
2728293031 



RSS feed RSS feed for Keith's Weblog
Atom feed Atom feed for Keith's Weblog
Weblog archive
Recent comments
  on 5 posts

Recent comments XML

new⇒Court rejects death penalty for raping children - Yahoo! News

Keith is not a person. I have this​on good authority. He's actually a​very,...

M. Bean: Jul 4, 2:05am

Girls, please don't get breast implants

> And no, you will not be receiving​a picture.

:-(...

Keith: Jul 2, 6:05am

Javascript clone function

This is a clever way to clone an​object if you are using YAHOO UI.​Same tec...

Antonio: Jul 1, 12:47pm

I hate Norton Antivirus

Oh just one other thing norton is​great at keeping people out of your​compu...

kevin.sands: Jul 1, 12:50am

Terminator 3 was awful

I think the biggest reason why T3​totally blew was because Edward​Furlong g...

76.167.172.64: Jun 29, 3:06am

Generated in about 0.046s.

(Used 7 db queries)

mobile phone