Baladodiffusion

 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,Attachement.clic,Attachement.niveau2,Attach_Cat.Label_fr FROM Attachement LEFT JOIN Attach_Cat ON Attachement.Categorie_attach=Attach_Cat.id WHERE Attachement.actif='3' and Attachement.repertoire_no=#attributes.repertoire_no# and Categorie_attach='2' ORDER BY Label_fr,Titre
<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">
#qryattach.photo_mini#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">
#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")#
#QryAttach.Attachement_texte#
#Right("#QryAttach.Attachement#",3)##Right("#QryAttach.Attachement#",4)##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#",4)##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#",4)##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#",4)##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#