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>
<% If (rsDB1_Database.Fields.Item("EmailAddressField".Value) <> "" Then %>
<img src="Images/Buttons/email.gif" width="22" height="14" border="0">
<% Else %>
& nbsp
<% End If %>
</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
<pre id=code><font face=courier size=2 id=code>
<% If (rsDB1_Database.Fields.Item("EmailAddressField".Value) <> "" Then %>
<img src="Images/Buttons/email.gif" width="22" height="14" border="0">
<% Else %>
& nbsp
<% End If %>
</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
Thank you VERY much.
PeMu
PeMu