User Profile

Collapse

Profile Sidebar

Collapse
Meditrina
Meditrina
Last Activity: Sep 18 '10, 11:52 PM
Joined: Sep 17 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Meditrina
    replied to IsNull or = "" not working
    in ASP Classic
    I fixed it. I could never figure out how to get a layered if statement to work, so ended up using LEN. This took care of it - works for Nulls or for blanks.
    See more | Go to post

      Leave a comment:

    • Meditrina
      started a topic IsNull or = "" not working
      in ASP Classic

      IsNull or = "" not working

      I have a database that contains 3 plaque inscriptions in fields plaque, plaque2 and plaque3. I am trying to get my asp page to display only the plaques if there is data in the field. Some of the fields are null and some are just empty (no null value).

      I have the following code, but I can't get it to work consistently:

      Code:
      <div class="personalizedPlaques" style="width: 185px">
      ...
      See more | Go to post
      • Meditrina
        replied to If statement when retrieving variable from database
        in ASP Classic
        If Statement

        Yes - thank you! That worked.
        See more | Go to post

          Leave a comment:

        • Meditrina
          started a topic If statement when retrieving variable from database
          in ASP Classic

          If statement when retrieving variable from database

          I have code that looks like this (pulling in 3 fields from a sql database), but I want it to only show the fields if <%=rs("UnitPric e3")%> is greater than 0. How do I write the if statement on my asp page?

          Code:
          <div class="orderItem">
<a href="http://www.xyz.com/eshop/shop.asp?productcode=<%=rs("ProductCode3")%>" title="Order"><img src="http://bytes.com/images/order.gif"
          ...
          See more | Go to post
          Last edited by jhardman; Sep 17 '10, 06:02 AM. Reason: added code tags. please use code tags in the future
          No activity results to display
          Show More
          Working...