SELECT Fiches.Web as webpath,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,Attachement.clic,Attachement.entree FROM Attachement LEFT JOIN Fiches ON Attachement.Repertoire_No = Fiches.Repertoire_No WHERE Attachement.Actif ='3' and (Attachement.repertoire_no=#attributes.repertoire_no# or Attachement.DB_Source=#attributes.repertoire_no#)Attachement.repertoire_no=#attributes.repertoire_no# and Attachement.Categorie_attach='22' <= #CreateODBCDate("#now()#")# ORDER BY entree desc,Titre

Documents pertinents

Document pertinent
<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" width="100" height="75">
#qryattach.photo_mini#http://#Replace("#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" width="100" height="75">
<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" width="100" height="75">
#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")#
#clic# vues
#LSDateFormat('#entree#','d mmmm yyyy')#
#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#