Display if field is NOT "" or NOT null
I have the following code which will display a region if a recordset field is not = "" (blank)
I need to add to it that is also NOT null.
I need to add to it that is also NOT null.
<% If rs_contactalert.Fields.Item("contact_alert_type").Value <> "" Then 'script %>
REGION
<% End If %>
Developer
CERTIFIED EXPERT
What is the database system? Why not solve it at the root itself? Add isnull(contact_alert_type,
What do you think?
What do you think?
contact_alert_type is the field of the recorset. if the field value is either NULL or "" then the region won't be displayed. I am not clear what you are asking.
Developer
CERTIFIED EXPERT
Okay...how is the recordset created? There must be a select statement somewhere if it is the kind of web applications I have been developing.
its a simple select. I will change it so that if its NULL then it will make it "" I can do that, but that was not the initial question for the IF statement.
