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("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#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")#","
","","all")#","

","#chr(13)##chr(10)#

","all")#","


","

#chr(13)##chr(10)#","all")#","


","

#chr(13)##chr(10)#","all")#","

","
#chr(13)##chr(10)#","all")#","

","
#chr(13)##chr(10)#","all")#","
#chr(13)##chr(10)#
","","all")#","
","","all")#","
","","all")#","

    ","
      ","all")#","

    ","
","all")#","

    ","
      ","all")#","

    ","
","all")#","
","
","all")#","
","","all")#","
","","all")#","
","","all")#","
","","all")#
#output.suggestion#Pour plus d'information

","		","all")#","

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