SELECT Titre, Repertoire_No, Sequence_No,Information, Categorie_No, niveau
FROM Fiches
WHERE Sequence_No=#attributes.Repertoire_No# AND (Categorie_No=0 OR Categorie_No IS NULL)#PublicationsQuery# AND (Actif='1' or Actif='3')
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=#attributes.Repertoire_No# AND NOT(Categorie_No=0 OR Categorie_No IS NULL) AND (Actif='1' or Actif='3')
ORDER BY Categorie_No, Societe
ArtistesAffiliationBottin municipalCommunautésFamilleÉcoles>ClassesÉlèvesMembres
- 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#
#Titre#
#Societe# (#Sigle#)
#Societe# (#Sigle#)
#Titre#
#Societe# (#Sigle#)
#Societe# (#Sigle#)
#Prenom# #Nom##Prenom# #Nom#
, #Fonction#
#replace (Division,chr(10),"
","all")#
#replace (Adresse ,chr(10),"
","all")#
#Ville#,
#Code_postal#
#Pays#
Tél. : #Telephone# #Telephone_desc# #replace (Telephone_desc,chr(10),"
","all")#
Tél. 2 : #replace (TelephoneA,chr(10),"
","all")# #replace (TelephoneA_desc,chr(10),"
","all")#
v 3 : #replace (TelephoneB,chr(10),"
","all")# #replace (TelephoneB_desc,chr(10),"
","all")#
Tél. 4 : #replace (TelephoneC,chr(10),"
","all")# #replace (TelephoneC_desc,chr(10),"
","all")#
Téléc. #Telecopieur# #Telecopieur_desc#
Courriel : #Courriel#
Web: #Web#
Autre site Web : #Web_anglais#