SELECT Titre, Repertoire_No, Sequence_No,Information, Categorie_No, niveau FROM Fiches WHERE #PreserveSingleQuotes(CatActifQuery)#Sequence_No=-589634889 AND (Categorie_No=0 OR Categorie_No IS NULL)#PublicationsQuery# ORDER BY Titre SELECT Web_anglais,Web,Courriel,niveau_courriel,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 FROM Fiches WHERE Sequence_No=-589634889 AND NOT(Categorie_No=0 OR Categorie_No IS NULL) AND (Actif='1' or Actif='3') ORDER BY Categorie_No, Tri, Titre, 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")#

#Prenom# #Nom# , #Fonction#

#Societe# (#Sigle#)
#Titre#
#Societe# (#Sigle#)
#Societe# (#Sigle#)
#replace (Division,chr(10),"
","all")#
#replace (Adresse ,chr(10),"
","all")#
#Ville# ()  #Code_postal#
#Pays#
#Telephone_desc#Tél. : #Telephone#
#TelephoneA_desc#Tél. : #TelephoneA#
#TelephoneB_desc#Tél. : #TelephoneB#
#TelephoneC_desc#Tél. : #TelephoneC#
Téléc. #Telecopieur# #Telecopieur_desc#
Courriel : #Courriel#
Web: #Web#
Autre site Web : #Web_anglais#