flog

...especially when it's b3tafied.

I've been tangling with this beast for about 3 or 4 days now and just had a breakthrough that I really don't want to forget. First off, a comment made by Erland Sommerskag in comp.database.ms-sqlserver about a more limited version of the problem pointed me in the right direction. Many thanks to him for that.

I'm storing questions and answers in a database which can obviously have question text and answer text. The users really want a "multilingual" view where a box will be shown for each question for each language to facilitate translation from English. The problem, though, is that until translation occurs there's only English text in the DB (mening there's only 1 box to show for each question).

I spent a couple of days trying continually more off the wall SQL statements to generate a query that would have NULL texts for those languages missing from each question, but would return only 1 entry for each language if there was already a text defined in that language. All this time, I've been working one level too low, however.

The solution was to start off at the question level, doing a cross join with the table that had all the languages defined in it (returning a table with NumQuestions x NumLanguages tuples/rows/records in it). Then I could do a LEFT OUTER JOIN with that result table to the questiontext table using a compound ON condition:

  SELECT tblLanguage.ID as Lang_ID, tblQuestion.Item_Id, QuestionName,

         LanguageReference, QuestionText

  FROM   (tblQuestion CROSS JOIN tblLanguage)

  LEFT OUTER JOIN tblQuestionText 

  ON tblQuestionText.Item_Id = tblQuestion.Item_Id 

  AND tblLanguage.ID = tblQuestionText.LanguageReference

  ORDER BY tblQuestion.Item_Id, Lang_ID

  

The result is a table that has NULL LanguageReference and QuestionText if no language has been defined otherwise the defined QuestionText for the given Language. On the form, some trickery has to be put into the QuestionText_BeforeUpdate() event handler since adding a new language that doesn't already exists will cause run-time errors (MS Access thinks that adding a new questiontext breaks referential integrity because you're changing one of the component fields of the "Primary Key" on QuestionText from NULL to a value). A new record containing the user entered text is inserted into the questiontext table using an ADO Recordset. Then the user-entered edit is canceled using Form.Undo. The form is then requeried to display the newly entered text.

I know you're not going to believe me, but I am not infatuated with Vin Diesel

I almost ran over a peacock on my way to work yesterday...or at least I think I did. The event was so strange that I'm not so sure now that it actually occurred.

Is anyone surprised by this finding that "exposure early in life to infections from household dust, germy siblings or surfaces may reduce the risk of developing disease in adulthood."

I recently converted over to μtorrent. Until then I had used Azureus for all my torrenting needs (except for a small amount of downloading with BT python client).

'Vorbau' can mean porch, the little knuckle piece that connects the handle bars to the neck and forks, something to do with growing rare tree species by culturing parts onto (or from) existing trees, as well as a wonderfully vulgar reference to a woman's tits. The literal components of the word mean 'forward-built thing'.

  Danny Glands:  On a California freeway, what is the minimum number of

                 bullet holes your car must sustain before the insurance

                 company considers you high risk?

         Kenny:  Of course, the answer is 5...my Jetta has 6.

  

Incidentally, that Flusher Fixer referenced previously fixed my leaky flapper wonderfully. I just wish my attempt at fixing the kitchen sink had been as successful.

The jingle of a dog's collar would be good right here --> .

Bloody eyeballs melt.
Fall asleep watching the kids;
Molester next door.

As it happens, lyrics are up on Beaver's website, The Beaver Lodge. To say I was close on Magic 7 is to be overly generous. At least the lines I got wrong were known unknowns...mostly.

I'm not sure what's so racy about these photos. Her nipples have been airbrushed out.

"Don't fuck with the DMV, Mr Anderson. We can make your life a living hell."

Kenny: Yeah, I like to fork for a while before I spoon.

  A magic spellbound seven

  Will equal mc square

  An equation from heaven

  A game of truth or dare...



  I know it's serious

  Makes success with me right

  She's professionally falling

  And it's sugar and it's spice



  They all escape

  Our master's so slight(?)

  Look at the daughter/dog law(?)

  The laws she seems to be fright



  I know it's serious

  Makes success with me right

  Seeds professionally falling

  And it's sugar, too, and it's spice 

  

Are you as dumb as a Rhode Islander? Take the test to find out.

I think this is probably the coolest unofficial fan site for a car wash establishment on myspace.

I saw a Prius yesterday driving around with the dealership EPA sticker still in the window. It seems strange that 48 MPG is lower than either of the numbers that were on that sticker.

And yet catholic ass sex inurl:hecat pulls up flog entries...I think it must be the Chinese forcing google to filter the entries returned for "catholic ass sex". </conspiracy>

And I thought that at least jack off motherfucker was a unique creation of mine, but no. Someone who dislikes Bukowski's poetry was struck by that muse, as well.