<div>
Unfortunately, VBScript does not have a &quot;short-circuit&quot; for the IF statement. So you will probably need to set a flag for each condition and use it to determine if you need to display your region. Try something like this:<br />

<pre><code id="code-20-41577878-1">&lt;%
Dim ShowRegion
ShowRegion = False
If rs_qnrpages.RecordCount = 0 Then
   ShowRegion = True
ElseIf rs_qnrpages.Fields.Item(&quot;pg_02_addresses&quot;).Value = (1) Then 
   ShowRegion = True
End If
If ShowRegion Then %&gt;
MY REGION
&lt;% End If %&gt;</code></pre>
Also, instead of using RecordCount, you could check if your recordset is at end of file (.EOF).
</div>


Unfortunately, VBScript does not have a "short-circuit" for the IF statement. So you will probably need to set a flag for each condition and use it to determine if you need to display your region. Try something like this:


<%
Dim ShowRegion
ShowRegion = False
If rs_qnrpages.RecordCount = 0 Then
   ShowRegion = True
ElseIf rs_qnrpages.Fields.Item("pg_02_addresses").Value = (1) Then 
   ShowRegion = True
End If
If ShowRegion Then %>
MY REGION
<% End If %>

Also, instead of using RecordCount, you could check if your recordset is at end of file (.EOF).

<div>
This seems to have worked and its easier.
</div>


This seems to have worked and its easier.

<div>
<div class="content wysiwyg-content">
I have a region that I need to show if a recordset is empty OR if the recordset is not empty AND the value of the field = 1<br />
<br />
This is the code I currently have to show it if the value = 1 &nbsp;I just need to add code to show it where that is the case OR if the recordset is empty<br />
<br />

<pre><code id="code-10-28943631-1">&lt;% If rs_qnrpages.Fields.Item(&quot;pg_02_addresses&quot;).Value = (1) Then 'script %&gt;
MY REGION
&lt;% End If  %&gt; </code></pre>
<br />
I need to add if 'rs_qnrpages' is empty OR the above then show that region.<br />
<br />
I am using ASP classic
</div>
</div>


I have a region that I need to show if a recordset is empty OR if the recordset is not empty AND the value of the field = 1

This is the code I currently have to show it if the value = 1  I just need to add code to show it where that is the case OR if the recordset is empty

(CODE)

I need to add if 'rs_qnrpages' is empty OR the above then show that region.

I am using ASP classic

Show region if recordset is empty or if its not empty and value  = 1

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

Web development includes all aspects of presenting content on intranets and the Internet, including delivery development, protocols, languages and standards, server software, browser clients, databases and multimedia generation.