SELECT titre, repertoire_no, sequence_no,information, categorie_no, niveau
FROM Fiches
WHERE #PreserveSingleQuotes(CatActifQuery)#Sequence_No=#attributes.Repertoire_No# AND (Categorie_No=0 OR Categorie_No IS NULL)
ORDER BY tri,titre
SELECT web_anglais,web,courriel,niveau_courriel,niveau5,telecopieur_desc,telecopieur,telephonec_desc,
telephonec,telephoneb_desc,telephoneb,telephoneb,telephonea_desc,telephonea,telephone_desc,
telephone,pays,code_postal,province,ville,adresse,division,fonction,nom,prenom,courriel1,
sigle,societe,sequence_no,repertoire_no,titre,categorie_no,type,photo_mini,titre,type,extrait,ville_desservie
FROM Fiches
WHERE Sequence_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, Nom, Prenom
Aucune fiche de disponible
#Titre#
#replace("#REReplace("#REReplace("#Categorie.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")#