SELECT Tri,Titre, Repertoire_No, Sequence_No,Information, Categorie_No, niveau,Id,Nature,Logo_mini,Logo_texte FROM Bottins WHERE #PreserveSingleQuotes(CatActifQuery)##PreserveSingleQuotes(CatListe)#Repertoire_No=#attributes.Repertoire_No# AND (Categorie_No=0 OR Categorie_No IS NULL) AND Nature='repertoire' ORDER BY Tri, Titre SELECT Categorie_No,Societe,Sigle,Information,Web,Logo_texte,Logo_mini,Titre,Tri,Id,Ville,Province FROM Bottins WHERE #PreserveSingleQuotes(ActifQuery)#Repertoire_No=#attributes.Repertoire_No# AND #PreserveSingleQuotes(CatQuery)#Nature='repertoire' ORDER BY Categorie_No, Tri, Societe

Répertoire

#Titre# | #Logo_texte##Titre# | #Logo_texte##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(13)##chr(10)#","
","all")#

Société Ville / Province
#Ville# ()