D
David Ehmer
The code below is 2 rows in a table, the top row contains a message to be
shown if the recordset returns no matches. The 2nd row will display any
matches.
Problem is that if no matches are found nothing is displayed in this table.
I have used the code that DMX generates using the server behaviour 'Show
region if recordset is empty', but no success.
Appreciate someone pointing out where I'm going wrong here.
Thanks
David
<table>
<tr>
<td>
<% If rsOrg.EOF Or rsOrg.BOF Then >
Sorry, no records were found to match your search.
<% End If ' end rsOrg.EOF And rsOrg.BOF %</td>
</tr>
<tr>
<td>
<% If Not rsOrg.EOF Or Not rsOrg.BOF Then %>
<a
href="<%=(rsOrg.Fields.Item("Web").Value)%>"><%=(rsOrg.Fields.Item("OrgName"
).Value)%></a>
<% End If ' end Not rsOrg.EOF Or NOT rsOrg.BOF %>
</td>
</tr>
</table>
http://www.boatingdirectory.com.au/aust_index.asp
shown if the recordset returns no matches. The 2nd row will display any
matches.
Problem is that if no matches are found nothing is displayed in this table.
I have used the code that DMX generates using the server behaviour 'Show
region if recordset is empty', but no success.
Appreciate someone pointing out where I'm going wrong here.
Thanks
David
<table>
<tr>
<td>
<% If rsOrg.EOF Or rsOrg.BOF Then >
Sorry, no records were found to match your search.
<% End If ' end rsOrg.EOF And rsOrg.BOF %</td>
</tr>
<tr>
<td>
<% If Not rsOrg.EOF Or Not rsOrg.BOF Then %>
<a
href="<%=(rsOrg.Fields.Item("Web").Value)%>"><%=(rsOrg.Fields.Item("OrgName"
).Value)%></a>
<% End If ' end Not rsOrg.EOF Or NOT rsOrg.BOF %>
</td>
</tr>
</table>
http://www.boatingdirectory.com.au/aust_index.asp