SELECT Attachement.Titre, Attachement.Extrait,Attachement.Description, Attachement.Photo_texte, Attachement.Attachement_texte, Attachement.Attachement,Attachement.Attachement_Poid,Attachement.Attachement2,Attachement.Attachement2_texte,Attachement.Attachement_Poid2,Attachement.Attachement3,Attachement.Attachement3_texte,Attachement.Attachement_Poid3,Attachement.Attachement4,Attachement.Attachement4_texte,Attachement.Attachement_Poid4,Attachement.Photo_mini,Attachement.Photo_texte,Attachement.Id,Attach_Cat.Label_fr FROM Attachement LEFT JOIN Attach_Cat ON Attachement.Categorie_attach=Attach_Cat.id WHERE #PreserveSingleQuotes(ActifQuery)#Source_Id=#attributes.Id# AND Module='#attributes.Module#' ORDER BY Tri,Titre

#Label_fr#

]*>", "", "ALL")##REReplace("#Titre#", "<[^>]*>", "", "ALL")# #attributes.Action#" title=" - #REReplace("#Photo_texte#", "<[^>]*>", "", "ALL")##REReplace("#Titre#", "<[^>]*>", "", "ALL")# #attributes.Action#" BORDER="1" ALIGN="LEFT" HSPACE="3" VSPACE="3">
<cfif len(Photo_texte)>#REReplace(

]*>", "", "ALL")##REReplace("#Titre#", "<[^>]*>", "", "ALL")# #attributes.Action#" title="#REReplace("#Photo_texte#", "<[^>]*>", "", "ALL")##REReplace("#Titre#", "<[^>]*>", "", "ALL")# #attributes.Action#" BORDER="1" ALIGN="LEFT" HSPACE="3" VSPACE="3">

#Titre##Titre#

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

#Right("#QryAttach.Attachement#",3)##Right("#QryAttach.Attachement#",2)#disquette_20.gif" BORDER="0" ALT="#attributes.Action1# le document #QryAttach.Attachement_texte#" title="#attributes.Action1# le document #QryAttach.Attachement_texte#" ALIGN="LEFT" HSPACE="2"> #QryAttach.Attachement_Poid##attributes.Action1#
#QryAttach.Attachement_texte#

#Right("#QryAttach.Attachement2#",3)##Right("#QryAttach.Attachement2#",2)#disquette_20.gif" BORDER="0" ALT="#attributes.Action2# le document #QryAttach.Attachement2_texte#" title="#attributes.Action2# le document #QryAttach.Attachement2_texte#" ALIGN="LEFT" HSPACE="2"> #QryAttach.Attachement_Poid2##attributes.Action2#
#QryAttach.Attachement2_texte#

#Right("#QryAttach.Attachement3#",3)##Right("#QryAttach.Attachement3#",2)#disquette_20.gif" BORDER="0" ALT="#attributes.Action3# le document #QryAttach.Attachement3_texte#" title="#attributes.Action3# le document #QryAttach.Attachement3_texte#" ALIGN="LEFT" HSPACE="2"> #QryAttach.Attachement_Poid3##attributes.Action3#
#QryAttach.Attachement3_texte#

#Right("#QryAttach.Attachement4#",3)##Right("#QryAttach.Attachement4#",2)#disquette_20.gif" BORDER="0" ALT="#attributes.Action4# le document #QryAttach.Attachement4_texte#" title="#attributes.Action4# le document #QryAttach.Attachement4_texte#" ALIGN="LEFT" HSPACE="2"> #QryAttach.Attachement_Poid4##attributes.Action4#
#QryAttach.Attachement4_texte#