SELECT Projets
FROM Fiches
WHERE Repertoire_No=#attributes.Repertoire_No#
SELECT Id,Titre,Description,Extrait
FROM Activites
WHERE niveau='2' and Repertoire_No=#attributes.Repertoire_No# and Categorie_No=999995 AND (Actif='3' or Actif='1')
ORDER BY Tri,Titre
SELECT Titre, Categorie_No, Sequence_No, Description, Extrait, Id, Repertoire_No
FROM Activites
WHERE Repertoire_No=#attributes.Repertoire_No# AND niveau='3' AND (Actif='1' or Actif='3')
ORDER BY Sequence_No,Tri,Titre
Projets
#replace("#REReplace("#REReplace("#Fiches.Projets#","([[:space:]])http://([^[:space:]]+?)(\.*[[:space:]])","\1\2\3","ALL")#","([[:space:]])([A-Za-z0-9_\.\-]+@[A-Za-z0-9\.\-]+\.[A-Za-z]{2,})(\.*[[:space:]])","\1\2\3","ALL")#",chr(10),"
","all")#