Recherche avancée

Sur d’autres sites (621)

• {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 (...)

• Les unions entre taules

  25 juillet 2010, par merce — Alguns exemples de bucles, Niveau: moyen, BOUCLE(ARTICLES), BOUCLE(MOTS), SPIP 2.0

  Exemples de bucles que produeixen una combinació múltiple entre 3 taules [spip 2.0.9] Volem, en un bucle, recuperar les informacions d’articles d’una (o diverses) secció a la que se li assigna una paraula clau (que nosaltres coneixem). crearà la petició sql següent : SELECT articles.id_rubrique, (...)