SELECT Modification,Exportation,Inventions,Realisations,Unites,Type,
Service_t,Services,nbemployes,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_mini,Photo,Repertoire,Extrait,Division,Origine,Nom,Prenom,fonction,courriel1,niveau2,niveau_courriel
FROM Fiches
WHERE Repertoire_No=#attributes.Art#
#Titre#
#Societe# (#Sigle#)
#Prenom# #Nom##Prenom# #Nom#, #Fonction#
#Societe# (#Sigle#)
#Prenom# #Nom##Prenom# #Nom#, #Fonction#
#Prenom# #Nom#
#Fonction#
#Societe# (#Sigle#)
#Titre#
#Societe# (#Sigle#)
#Prenom# #Nom##Prenom# #Nom#, #Fonction#
#Societe# (#Sigle#)
#Prenom# #Nom##Prenom# #Nom#, #Fonction#
#Prenom# #Nom#
#Fonction#
#Societe# (#Sigle#)
#Titre#
#Societe# (#Sigle#)
#Prenom# #Nom##Prenom# #Nom#, #Fonction#
#Societe# (#Sigle#)
#Prenom# #Nom##Prenom# #Nom#, #Fonction#
#Prenom# #Nom#
#Fonction#
#Societe# (#Sigle#)
#Division#
#replace (Adresse ,chr(10),"
","all")#
#Ville# () #Code_postal#
#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#
Site Web : #Web#
Autre site Web : #Web_anglais#
#replace (Annee,chr(10),"
","all")#
Lieu d'origine : #replace (Origine,chr(10),"
","all")#
#replace("#REReplace("#REReplace("#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")#","\[\[([^\]\]]+?)\]\]","\1","ALL")#",
"#chr(13)##chr(10)#","
#chr(13)##chr(10)#","all")#",
"
","","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 (nbemployes,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")#
« Retour