SELECT * FROM Nouveautes WHERE #PreserveSingleQuotes(LieuQuery)#Repertoire_No=#attributes.Repertoire_No# AND (Actif='3' or Actif='1')#PreserveSingleQuotes(GlobalQuery)# ORDER BY Entree desc;

Manchettes

#Nouveautes_interne.Sujet#
#Nouveautes_interne.Sujet#
#Nouveautes_interne.Contact##Nouveautes_interne.Contact#, #Nouveautes_interne.Source##Nouveautes_interne.Source#, le #LSDateFormat("#Nouveautes_interne.Entree#","d mmmm yyyy")#

#replace("#REReplace("#REReplace("#REReplace("#Nouveautes_interne.Message#","#chr(13)##chr(10)##chr(13)##chr(10)#","

","all")#","#chr(13)##chr(10)#","","all")#","([[: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")#

#REReplace("#Temp#", "<[^>]*>", "", "ALL")# suite...suite...