Skip navigation
Currently Being Moderated

Hide Images from DB

Apr 20, 2006 9:00 AM

How can you completely hide placeholders [X] in a table cell when images,
are NOT to be shown or called from a database?
Like here - http://www.webewitch.com/classifieds/classads_basic.asp
Thanks
Gary


 
Replies
  • Currently Being Moderated
    Apr 20, 2006 12:16 PM   in reply to Newsgroup_User
    This is probably the easiest thing I have looked at all day. First, make sure you have a 1px transparent image. I am also assuming that you are calling your images from a file and that the name is being pulled by a recordset from a name in your database and that the code loops until EOF. If so, use the following code block where your image recordset is:

    <%Dim PicShow
    PicShow = rsEx2.Fields.Item("shMainPic").Value
    IF PicShow <>"" THEN%>
    <img src="<%=PicShow%>">
    <%ELSE%>
    <img src="pix/no_pic.jpg">
    <%End If%>

    Now, I know you are probably asking, "What are we doing?"

    - First we are declaring a Variable and naming it PicShow .
    - Next we give PicShow a value equal to the contents of rsEx1.Fields.Item("shMainPic").Value
    - We then start our IF THEN routine by saying that IF the contents of PicShow is not empty (<> -- not equal to "" -- empty) THEN we must execute the next line of code. Which happens to be <img src="<%=PicShow%>"> (remember that PicShow now holds the value of the image path)
    - So what happens if PicShow IS empty? That's where the ELSE comes in with ELSE execute the next line of code. Which happens to be a standard HTML image path to our default image " <img src="pix/no_pic.jpg"> "
    - END IF tells the page that this particular IF THEN routine is over!

    In short ........... IF the dynamic picture field is not empty THEN display the dynamic picture, otherwise ELSE display a standard static picture.

    Let me know if this is clear or not. Good luck and keep coding!
     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)