SELECT Fiches.Web as webpath,Communiques.Date,Communiques.Titre,Communiques.Titre_autre,Communiques.Photo,Communiques.id, Communiques.Source,Communiques.Courriel,Communiques.Ville,Communiques.Description,Communiques.Description_autre, Communiques.Attachement,Communiques.Attachement_Poid,Communiques.Attachement_texte, Communiques.Publication,Communiques.Section,Communiques.Auteur,Communiques.renseignements,Communiques.renseignements_autre, Communiques.Edition,Communiques.Photo_texte,Communiques.Photo_mini,Communiques.Photo1_texte, Communiques.Suggestion,Communiques.Contact,Communiques.Repertoire_No,Communiques.Web as CommWeb FROM Communiques LEFT JOIN Fiches ON Communiques.Repertoire_No = Fiches.Repertoire_No WHERE #PreserveSingleQuotes(attributes.QRYString)#

Press Release

Français

#attributes.embargo#

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

#Source#

- 30-

#Publication# - #Section#
Author : #Auteur##Auteur#
Edition : #Edition#

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

Press Release

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

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