Recherche avancée

Sur d’autres sites (691)

• {collecte}

  17 août 2010, par Mark — Criteria

  The collecte criteria is used to specify the "collation" to use for the request generated by the loop (by making a call with the "COLLATE" clause in MySQL [1]). The collecte criterion, (since SPIP 2.0), is used to force the SQL query generated by the loop to which it is attached to use a (...)

• Joins between tables

  17 août 2010, par Mark — A few examples of loops

  Some examples of loops that generate multiple joins between 3 tables [spip 2.0.9] We would like, in a single loop, to retrieve the data from some articles from one (or several) sections to which a predetermined keyword has been assigned. will generate the following SQL query : SELECT (...)

• #DOUBLONS

  17 août 2010, par Mark — Tags

  #DOUBLONSkeywords or #DOUBLONSkeywords,family outputs the status of the duplicates tagged with (KEYWORDS) at this location in the code, in the form of an array of id_mot values : array(1,2,3,...) #DOUBLONS just by itself generates the raw list of all the duplicates. #DOUBLONS*keywords generates (...)