Show region if recordset is not empty

[faiz2000]

Hi?

How can I make server behavior for this?:

If Diet field empty in the food table,Don?t display Diet word in the Page

<% If Not Food.EOF Or Not Food.BOF Then %>
<font color="#FF0000" face="Tahoma, Verdana">Diet</font>
<% End If ' %>

Please your help ASAP

[Joe Makowiec]

On 04 Sep 2005 in macromedia.exchange.extensions.dreamweaver, faiz2000
wrote:

> If Diet field empty in the food table,Don?t display Diet word in
> the Page
>
> <% If Not Food.EOF Or Not Food.BOF Then %>
> <font color="#FF0000" face="Tahoma,
> Verdana">Diet</font> <% End If ' %>
>
> Please your help ASAP

That would work for a recordset, and you can access it in the Server
Behaviors panel. Highlight the dynamic text, click the '+' button, and
select 'show if not empty'.

However, if you mean an individual field in a record in a recordset,
something like:

Record1 xyzzy diet
Record2 shazam diet
Record3 yabba
Record4 please diet

then you need to do something like this:

<% IF (recordset1.Fields.Item("Diet").Value <> "") THEN
' what to do if Diet exists goes here
ELSE
' what to do if no Diet
END IF %>

--
Joe Makowiec
[url]http://makowiec.net/[/url]
Email: [url]http://makowiec.net/email.php[/url]