SELECT Id, Photo, Pub_texte, Target, Web, Width, Height, niveau3 FROM Promo WHERE Repertoire_No = #attributes.Repertoire_No# AND (Actif='1' OR Actif='3') AND niveau2='Pub04' AND Date_debut <= #CreateODBCDate(now())# AND Date_fin >= #CreateODBCDate(now())# ORDER BY tri,Id

#Photo#http://#Replace("#GetBaseInfo.Web#","http://","","ALL")#/images/#Photo#">#Photo#http://#Replace("#GetBaseInfo.Web#","http://","","ALL")#/images/#Photo#" menu=false quality=high WIDTH="#width#" HEIGHT="#height#" ALIGN="MIDDLE" TYPE="application/x-shockwave-flash" PLUGINSPAGE="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash"><cfif len(Pub_texte)>#Pub_texte# - </cfif>Cliquez ici !<cfif len(Pub_texte)>#Pub_texte# - </cfif>Cliquez ici !