Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    London
    Posts
    341

    Question Unanswered: If entry is blank, display x

    Hi, I'm not sure if this is a VB or an ASP problem but I hope you could help.

    I have an asp page which is pulling some data from our SQL database and displaying using some vb script.

    Code:
    <tr>
     <td width="200"><strong><%=objData.getLabel("HESA/HESA/ClinSub", , Language)%></strong></td>
      <td><%=objData.getPrePostAndValue("HESA/HESA/ClinSub", , Language)%></td></tr>
    In some cases, these fields need to be blank and I want to put an explanation against them stating this. What I need is something that says, if "ClinSub" is blank, then display message "This needs to be blank because..."

    Can someone offer any suggestions as to how I do this?

  2. #2
    Join Date
    Oct 2003
    Location
    London
    Posts
    341
    So sorry for wasting anyone's time but i've now resolved it by adding the following if statement after my retrieval code.

    Code:
    <%if objData.getPrePostAndValue("HESA/HESA/ClinSub", , Language) = "" Then response.write "Not applicable" end if %>
    Thank you for looking.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •