Da’s gerief.

<CFQUERY name=”qProdList” datasource=”#request.app.mainDSN#”>

SELECT PRODTYPE_DETAILXSL, PRODTYPE_CODE, prodType_ID 
  FROM tblProdList

          INNER JOIN tblProdTypes ON prodList_prodType_ID = ProdType_ID 
  WHERE ProdList_ID = ‘#arguments.ID#’

</CFQUERY>

<CFQUERY name=”qProdListRules” datasource=”#request.app.mainDSN#”>

SELECT *

FROM   tblProdListRules INNER JOIN tblProdFields 
            ON tblProdListRules.prodListRule_prodField_ID=tblProdFields.prodField_ID

WHERE  ProdListRule_ProdList_ID='{#arguments.ID#}’

</CFQUERY>

<CFQUERY name=”qProducts” datasource=”#request.app.mainDSN#”>

  select tblProducts.* from tblProducts

  <CFLOOP query=”qProdListRules”>

    inner join tblProdData#ProdField_FT# tbl#qProdListRules.currentrow#

    on tbl#qProdListRules.currentrow#.proddata_Field_id = ‘{#ProdField_id#}’

    and tbl#qProdListRules.currentrow#.proddata_prod_id = tblProducts.product_ID

    and tbl#qProdListRules.currentrow#.proddata_data

    <CFIF ProdField_ft EQ “NUM”>

      #prodListRule_qualifier# #prodListRule_value#

    <CFELSE>

      <CFIF ProdField_inputtype EQ “text”>

        #prodListRule_qualifier# ‘#prodListRule_value#’

      <CFELSE>

      #prodListRule_qualifier# ‘#prodListRule_value#’

      </CFIF>

    </CFIF>

  </CFLOOP>

where product_prodType_ID = ‘{#qProdList.prodType_ID#}’

</CFQUERY>

Tiens, nu ik erover denk, ik heb vorige vrijdag de moeder van Bruno in de GB aan de Dampoort gezien.

Zelie: “Mijn popje heet Palima. En mijn popjeheet ook Filipaliminapifa. DA’s een rare naam hé?”

Ik denk dat ze verkeerd eten krijgt 🙂

Leaked NSA memo absent from US media

The story about the allaged leaked NSA “dirty tricks” memo that appeared in the Observer on Sunday is making the rounds in the world’s media. After looking around, I can easily find the story in British, Norwegian, French, German, Italian, Canadian, Russian, Australian, Middle-East and Far East media. There is a country; there is a newspaper writing about it, and mostly the story has prominent placing..

Except (you guessed it), in the US.

Its mention in mainstream US media is basically zilch. Honourable exceptions are Slate (though hidden inside an article about something else) and Washington Times, even though the latter only mentions it (in “foreign dispatches”) to question its authenticity (as does WTVJ in Florida). Some very few non-mainstream US newssources also carry the story.

In the blogsphere, on the other hand, the Observer story is currently the top two most referenced links, according to Daypop. Its authenticity and impact is also heavily debated in blogs. But the US media is silent.

Liberal bias? You must be joking.

[Secular Blasphemy]

The saga continues: