SELECT Attachement.Titre, Attachement.Extrait,Attachement.Description, Attachement.Photo,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(AlphaSearch)##PreserveSingleQuotes(DBQuery)##PreserveSingleQuotes(GlobalQuery)##PreserveSingleQuotes(LieuQuery)##PreserveSingleQuotes(SecteurQuery)##attributes.Srchin#.Langue LIKE '%fr%'and Attachement.actif='3'#PreserveSingleQuotes(SrchtypeQuery)# ORDER BY Label_fr,Titre

#QryAttach.recordcount# éléments répertoriésélément répertorié

#Label_fr#Divers

<cfif len(qryattach.Photo_texte)> - #REReplace(]*>", "", "ALL")##REReplace("#qryattach.Titre#", "<[^>]*>", "", "ALL")# #attributes.Action#" title=" - #REReplace("#qryattach.Photo_texte#", "<[^>]*>", "", "ALL")##REReplace("#qryattach.Titre#", "<[^>]*>", "", "ALL")# #attributes.Action#" BORDER="1" ALIGN="middle" HSPACE="3" VSPACE="3">
#attributes.HREF#http://#Replace("#attributes.webpath#","http://","","ALL")#/images/#qryattach.Photo_mini#" alt=" - #REReplace("#qryattach.photo_texte#", "<[^>]*>", "", "ALL")##REReplace("#qryattach.Titre#", "<[^>]*>", "", "ALL")# #attributes.Action#" title=" - #REReplace("#qryattach.Photo_texte#", "<[^>]*>", "", "ALL")##REReplace("#qryattach.Titre#", "<[^>]*>", "", "ALL")# #attributes.Action#" BORDER="1" ALIGN="middle" HSPACE="3" VSPACE="3">
#CurrentRow#. #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")#
#QryAttach.Attachement_texte#
#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.Attachement2_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.Attachement3_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.Attachement4_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#