SELECT Modification,Exportation,Inventions,Realisations,Unites,Type,
Service_t,Services,No_Employes,Mission,Information,Projets,Annee,Web_anglais,Web,Courriel,
Telecopieur_desc,Telecopieur,TelephoneC_desc,TelephoneC,TelephoneB_desc,TelephoneB,
TelephoneB,TelephoneA_desc,TelephoneA,Telephone_desc,Telephone,Pays,Code_postal,
Province,Ville,Adresse,Fonction,Nom,Prenom,Courriel1,Sigle,Societe,Titre,Photo_texte,Photo,Repertoire,Extrait,Division,Origine,Nom,Prenom,fonction,courriel1
FROM Fiches
WHERE Repertoire_No=#attributes.Art#
#Titre#
#Societe# (#Sigle#)
#Division#
#Prenom# #Nom##Prenom# #Nom#, #Fonction#
#Prenom# #Nom#
#Fonction#
#replace (Adresse ,chr(10),"
","all")#
#Ville#
#Ville#,
#Code_postal#
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")#
Tél. 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#
Site Web: #Web#
Autre site Web : #Web_anglais#
Date de naissanceAnnée de fondation : #replace (Annee,chr(10),"
","all")#
Lieu d'origine : #replace (Origine,chr(10),"
","all")#
#replace("#REReplace("#REReplace("#Extrait#","([[: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")#
#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")#
MandatDémarche artistiqueMission et mandat
#replace("#REReplace("#REReplace("#Mission#","([[: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")#
Nombre d'employés
:
#replace (No_Employes,chr(10),"
","all")#
Services
#replace("#REReplace("#REReplace("#Services#","([[: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")#
Produits
#replace("#REReplace("#REReplace("#Service_t#","([[: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")#
Nombre d'unités disponibles :
#replace (Unites,chr(10),"
","all")#
Projets
#replace("#REReplace("#REReplace("#Projets#","([[: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")#
Réalisations
#replace("#REReplace("#REReplace("#Realisations#","([[: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")#
Innovations
#replace("#REReplace("#REReplace("#Inventions#","([[: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")#
Exportation
#replace("#REReplace("#REReplace("#Exportation#","([[: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")#