SELECT Modification,Exportation,Inventions,Realisations,Unites,Type,photo_mini,
Service_t,Services,nbemployes,Mission,Information,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
FROM Fiches
WHERE Repertoire_No=#attributes.Art#
#Titre#
#Societe# (#Sigle#)
#Division#
#Prenom# #Nom#
#Fonction#
#replace (Adresse ,chr(10),"
","all")#
#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#
#replace (Extrait ,chr(10),"
","all")#
Date de naissanceAnnée de fondation : #replace (Annee,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 (Mission ,chr(10),"
","all")#
Nombre d'employés
:
#replace (nbemployes,chr(10),"
","all")#
Services
#replace (Services,chr(10),"
","all")#
Produits
#replace (Service_t,chr(10),"
","all")#
Nombre d'unités disponibles :
#replace (Unites,chr(10),"
","all")#
Réalisations
#replace (Realisations,chr(10),"
","all")#
Innovations
#replace (Inventions,chr(10),"
","all")#
Exportation
#replace (Exportation,chr(10),"
","all")#