function ConvertSpecialChars(textin) { return ReplaceList(textin, "#chr(149)#,’,#chr(156)#,#chr(140)#,#chr(133)#,#chr(150)#,#chr(151)#,#chr(145)#,#chr(146)#,#chr(147)#,#chr(148)#", "•,',oe,OE,...,-,-,',',"","""); } SELECT * FROM Agenda3 WHERE Id=#URL.Id# ORDER BY date_debut SELECT Titre,Extrait,Description FROM Activites WHERE Id=#output.Source_Id# SELECT titre,extrait,description FROM sections_pages WHERE Id=#output.pageid# SELECT Fiches.societe,Fiches.lieu,Fiches.information,technique.billetterie,technique.billetterie_info,technique.billetterie_url FROM fiches LEFT JOIN technique ON fiches.repertoire_no = technique.repertoire_no WHERE fiches.repertoire_no=#output.salleid#


#output.Titre# #output.Titre# #output.Titre# #output.Titre#

#Replace("#output.artiste#","#chr(13)##chr(10)#","
","ALL")#

#output.artiste_url#http://#output.artiste_url#" target="_blank">

#Replace("#output.artiste#","#chr(13)##chr(10)#","
","ALL")#

 #Replace("#output.artiste#","#chr(13)##chr(10)#","
","ALL")#

#Replace("#output.activite#","#chr(13)##chr(10)#","
","ALL")#

#replace("#REReplace("#REReplace("#REReplace("#REReplace("#output.Description#","([[: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")#
#output.suggestion#Pour plus d'information

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

#output.suggestion#Pour plus d'information

Pour plus d'information

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

#output.suggestion#Pour plus d'information

Première partie :

#Replace("#output.artiste1#","#chr(13)##chr(10)#","
","ALL")# #output.artiste1_url#http://#output.artiste1_url#" target="_blank">#Replace("#output.artiste1#","#chr(13)##chr(10)#","
","ALL")# #Replace("#output.artiste1#","#chr(13)##chr(10)#","
","ALL")#

#Replace("#output.activite1#","#chr(13)##chr(10)#","
","ALL")#

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

Deuxième partie :

#Replace("#output.artiste2#","#chr(13)##chr(10)#","
","ALL")# #output.artiste2_url#http://#output.artiste2_url#" target="_blank">#Replace("#output.artiste2#","#chr(13)##chr(10)#","
","ALL")# #Replace("#output.artiste2#","#chr(13)##chr(10)#","
","ALL")#

#Replace("#output.activite2#","#chr(13)##chr(10)#","
","ALL")#

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

Quand :

#DateFormat("#output.date_debut#","d")# #lsDateFormat("#output.date_debut#","mmm")# #DateFormat("#output.date_debut#","yyyy")##DateFormat("#output.date_debut#","d")# #lsDateFormat("#output.date_debut#","mmm")# #DateFormat("#output.date_debut#","yyyy")# - #DateFormat("#output.date_fin#","d")# #lsDateFormat("#output.date_fin#","mmm")# #DateFormat("#output.date_fin#","yyyy")#

Heures :

#TimeFormat(Heure_debut, "H")#h#TimeFormat(Heure_debut, "mm")# - #TimeFormat(Heure_fin, "H")#h#TimeFormat(Heure_fin, "mm")#

Heure :

#TimeFormat(Heure_debut, "H")#h#TimeFormat(Heure_debut, "mm")#

Horaire :

#Replace("#output.horaire#","#chr(13)##chr(10)#","
","ALL")#

Saison :

#Replace("#output.periode#","#chr(13)##chr(10)#","
","ALL")#

Où :

#salle.societe#

Indication routière :

#replace("#REReplace("#REReplace("#REReplace("#REReplace("#salle.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")#","\[\[([^\]\]]+?)\]\]","\1","ALL")#","#chr(13)##chr(10)#","
#chr(13)##chr(10)#","all")#","
","","all")#

Où :

#replace("#REReplace("#REReplace("#REReplace("#REReplace("#output.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")#","\[\[([^\]\]]+?)\]\]","\1","ALL")#","#chr(13)##chr(10)#","
#chr(13)##chr(10)#","all")#","
","","all")#

Ville :

#output.Ville#

Coût des billets :

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

Information :

#replace("#REReplace("#REReplace("#REReplace("#REReplace("#output.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")#

Information :

#replace("#REReplace("#REReplace("#REReplace("#REReplace("#salle.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")#

Billetterie :

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

Billetterie :

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

Billetterie en ligne :

#billetterie_url#http://#billetterie_url#" title="Achat de billet" target="_blank">Achat de billets

Achat :

#salle.billetterie_url#http://#billetterie_url#" title="Achat de billet en ligne" target="_blank">Achat de billets en ligne

DiffuseurProducteurCoordonné parPrésentateur :

">#output.Presentateur# [#output.Web_presentateur#http://#output.Web_presentateur#" target="_top">Web] #output.Presentateur#
Tél. : #output.telephone#

Crédits :

#Replace("#output.credits#","#chr(13)##chr(10)#","
","ALL")#

Commentaires :

#Replace("#output.commentaires#","#chr(13)##chr(10)#","
","ALL")#

Événement :

#evenement_url#http://#evenement_url#" title="Achat de billet en ligne" target="_blank">#output.evenement# #output.evenement#


Réseau Ontario jVais

« Retour
]*>", "", "ALL")#"">#chr(13)##chr(10)#"> ]*>", "", "ALL")#"">#chr(13)##chr(10)#"> #chr(13)##chr(10)#">#chr(13)##chr(10)#"> #chr(13)##chr(10)#"> #chr(13)##chr(10)#"> ]*>","","ALL"),150)#"">#chr(13)##chr(10)#">#chr(13)##chr(10)#"> #chr(13)##chr(10)#"> ]*>", "", "ALL")#"">#chr(13)##chr(10)#"> #chr(13)##chr(10)#">#chr(13)##chr(10)#"> #chr(13)##chr(10)#"> #chr(13)##chr(10)#"> #chr(13)##chr(10)#"> #chr(13)##chr(10)#"> ]*>","","ALL"),150)#"">#chr(13)##chr(10)#">#chr(13)##chr(10)#"> #chr(13)##chr(10)#"> UPDATE agenda3 SET clic = Clic + 1 WHERE Id=#URL.Id#