#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")#
#adresse_line2#
#adresse_line3#
#Ville# ()  #Code_postal#

Tél. : #Telephone# #Telephone_desc#
#TelephoneA_desc# :     #TelephoneA#
#TelephoneB_desc# :     #TelephoneB#
#TelephoneC_desc# :     #TelephoneC#
Téléc. : #Telecopieur# #Telecopieur_desc#
Courriel : #Courriel#
Webs : #Web# Web : • #Web_anglais#

Date de naissanceAnnée de fondation : #replace (Annee,chr(10),"
","all")#

Lieu d'origine : #replace (Origine,chr(10),"
","all")#
SELECT Fiches.societe,Fiches.repertoire_no,Fiches.lieu FROM fiches WHERE fiches.repertoire_no IN (#GetFicheInfo.salleid#)

Lieux de diffusion

#societe#

#equipe_t#

#replace("#REReplace("#REReplace("#equipe#","([[: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")#

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")#

#experience_t#

#replace("#REReplace("#REReplace("#experience#","([[: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")#

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")#

Activités

#replace("#REReplace("#REReplace("#activites#","([[: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")#

#inventions_t#

#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")#

Projets

Expériences en milieu scolaire

Réalisations

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")#

Nouveautés

#replace("#REReplace("#REReplace("#nouveautes#","([[: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")#

#divers16_t#

#replace("#REReplace("#REReplace("#divers16#","([[: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")#

#divers17_t#

#replace("#REReplace("#REReplace("#divers17#","([[: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")#

À vendre

#replace("#REReplace("#REReplace("#vendre#","([[: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")#

Nous cherchons

#replace("#REReplace("#REReplace("#recherche#","([[: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")#

Pour nous joindre

#replace("#REReplace("#REReplace("#lieu#","([[: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")#

Services en français : #langue_service#
Thème : #replace (Classement,"#chr(13)##chr(10)#",", ","all")#
Services offerts : #replace (Domaine_details,",",", ","all")#

Modification : #DateFormat("#Modification#","yyyy-mm-dd")#

« Retour

UPDATE fiches SET clic = Clic + 1 WHERE repertoire_no=#attributes.art#