I have a problem, when all fields are emty (FlyerURL, FotoURL) there isn't the Message for no Picture, there is always the URL from the FlyerURL Field (which is emty)
quote: <% if len(rs.fields("FlyerURL")) < 5 then if len(rs.fields("FotoURL")) < 5 then Response.write("Kein Flyer/Foto<br>vorhanden!") else Response.write("<img src='" & rs("FotoURL") & "' width='100' border='0'>") end if else Response.write("<img src='" & rs("FlyerURL") & "' width='100' border='0'>") end if %>
Perhaps change this: if len(rs.fields("FlyerURL")) < 5 then if len(rs.fields("FotoURL")) < 5 then
To be more like this instead: if (len(rs.fields("FlyerURL")) < 5) or IsNull(rs.fields("FlyerURL")) then if (len(rs.fields("FotoURL")) < 5) or IsNull(rs.fields("FotoURL")) then
J. Paul Schmidt - ASP Web Developer www.Bullschmidt.com - To put live data on the Web...