ASP and/or HTML Table Question **Resolved**

[Mark Gambo]

I just started playing around with ASP and I am able to display data from a MS SQL db. One question I have that some of the rows from my query have fields that have either null or "" values. When these rows are displayed in the table the borders for those fields are not printed. I have tried appending and empty string to each field but to no avail.

Here is my Code:

Do While Not rstSimple.EOF
    %>
    <tr>
        <td><%= rstSimple.Fields("Incident_Type").Value%></td>
        <td><%= rstSimple.Fields("Filenum").Value%></td>
        <td><%= rstSimple.Fields("CASENUM").Value%></td>
        <td><%= rstSimple.Fields("STATUS").Value%></td>
    </tr>
    <%
    rstSimple.MoveNext
Loop

[mendhak]

Check for a null value, and if it's null, print an   instead.

[mendhak]

 

^--- that. Didn't show up in the first post.

[Mark Gambo]

Thanks, that did the trick. I just added it after each field:

<TD><%=rstSimple.Fields("Incident_Type").Value%> %nbsp</TD>

Are there any problems with the above code?

Can I use the IIF() command to check for a null value?

Thanks,

(Sent from my Treo 600)

[davebat]

use

<%
if trim(rstSimple.Fields("Incident_Type").Value) = "" then
  response.write "&nbsp;"
else
  response.write rstSimple.Fields("Incident_Type").Value
end if
%>

[Mark Gambo]

mendhak and DaveBat,

Thank you very much. Your posts were right on the money.


One last question and I promise this is it. In the table I am displaying Serial Numbers, and I want the user to be able to click on the serial number (Hyperlink) and then load another page. I tried this:

<TD><%=rstSimple.Fields("Incident_Type").Value%> %nbsp <A HREF =rstSimple.Fields("Incident_Type").Value </a></TD>

But I am getting an error. Any suggestions?

[Mark Gambo]

I figure it out:

<TD><A HREF="NotInstalled.HTM"><%=rstSimple.Fields("Incident_Type").Value%></A></TD>

Thanks Again!!!