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,bottin FROM Fiches WHERE Sequence_No=#attributes.Repertoire_No# AND NOT(Categorie_No=0 OR Categorie_No IS NULL) 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")#
  1. #bottin# #Prenom# #Nom#, #Fonction#
    2.
    #Societe# (#Sigle#)
  2. #bottin# #Titre#
    #Societe# (#Sigle#)
  3. #bottin# #Societe# (#Sigle#)
    4.