SELECT Tri,Titre, Repertoire_No, Sequence_No,Information, Categorie_No, niveau,Id,Nature FROM Bottins WHERE #CategorieQuery#Repertoire_No=#attributes.Repertoire_No# AND (Categorie_No=0 OR Categorie_No IS NULL) AND Nature='partenaire' AND (Actif='1' OR Actif='3') ORDER BY Tri, Titre SELECT Categorie_No,Societe,Sigle,Information,Web,Logo_texte,Logo_mini,Titre,Tri FROM Bottins WHERE #PartenaireQuery#Repertoire_No=#attributes.Repertoire_No# AND NOT (Categorie_No=0 OR Categorie_No IS NULL) AND (Actif='1' OR Actif='3') ORDER BY Categorie_No, Tri, Societe SELECT Partenaires FROM Fiches WHERE Repertoire_No = #attributes.Repertoire_No#

#replace("#REReplace("#REReplace("#Partenaires#","([[: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")#

#Titre#

#replace("#REReplace("#REReplace("#Information#","([[: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")#