Keith Devens .com |
Friday, July 4, 2008 | ![]() |
| Never ascribe to malice, that which can be explained by incompetence. – Napoleon Bonaparte | ||
Archive: March 05, 2004
|
| 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?
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 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.
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, 2004 | March 08, 2004 → |
Generated in about 0.046s.
(Used 7 db queries)

new⇒Court rejects death penalty for raping children - Yahoo! News
Keith is not a person. I have thison good authority. He's actually avery,...
M. Bean: Jul 4, 2:05am