Forums

This topic is locked

UDev and IF - function

Posted 20 Oct 2001 14:48:38
1
has voted
20 Oct 2001 14:48:38 Petra Murbach posted:
I have tried a lot, but it did not work:

I want to show an image (email-envelope) in a UDev-table only if there is an emailadress of the person in the database. If the person does not have any emailadress the picture should not be shown.

NOW:
In using the serveroptions it is only possible to show an image if the whole DATASET is empty or not. But it is not possible to make this query on only a databaseFIELD.

Do you have any ideas???

Thank you for your help.

PeMu.

Here is the generated Code of the example above:

<% If Not rsDB1_Database.EOF Or Not rsDB1_Database.BOF Then %>
<img src="Images/Buttons/email.gif" width="22" height="14" border="0">
<% End If ' end Not rsDB1_Database.EOF Or NOT rsDB1_Database.BOF %>


PeMu

Replies

Replied 20 Oct 2001 15:26:00
20 Oct 2001 15:26:00 Owen Eastwick replied:
Try it like this:
<pre id=code><font face=courier size=2 id=code>
&lt;% If (rsDB1_Database.Fields.Item("EmailAddressField".Value) &lt;&gt; "" Then %&gt;
&lt;img src="Images/Buttons/email.gif" width="22" height="14" border="0"&gt;
&lt;% Else %&gt;
& nbsp
&lt;% End If %&gt;
</font id=code></pre id=code>

(remove the space from between <b>&</b> and <b>nbsp</b>

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

Edited by - oeastwick on 10/20/2001 15:27:11
Replied 20 Oct 2001 16:54:12
20 Oct 2001 16:54:12 Petra Murbach replied:
<img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle> IT WORKED GREAT!!!!! <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

Thank you VERY much.


PeMu

PeMu

Reply to this topic