I can't seem to get the syntax right. I am populating from a DB recordset. What I'd like to achieve is if either the individual recordset column is blank or the recordset itself is "broken" or "missing" then in its place would be: "No Record" rather than the page throwing an error. Here's what I've been playing with:
Set rsHeat_cmd = Server.CreateObject ("ADODB.Command")
n = MM_heat_STRING
rsHeat_cmd.CommandText = "SELECT * FROM display"
rsHeat_cmd.Prepared = true
Set rsHeat = rsHeat_cmd.Execute
rsHeat_numRows = 0
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd
<% If (rsHeat.Fields.Item("Heat"
).Value) = "" Then
If (rsHeat_total = 0) Then %>
<% Else %>
<% End If
Set rsHeat = Nothing