Forums

This topic is locked

Show and hide

Posted 19 Feb 2004 18:31:54
1
has voted
19 Feb 2004 18:31:54 Alfa Siete posted:
My database shows a field for special prices of the products, normally discontinued items, or Off the season items. A sub program fills the field with the value, if the item is in special it shows the special price, let's say $100.00 if the product is not on special sale the subprogram writes $0.00 on the field. this makes impossible for me to use the hide-show region regular extensions. any ideas for hiding the 0.00 in the items not on special sale??

Everybody should belive in something... I belive i'm having another beer

Replies

Replied 24 Feb 2004 14:33:35
24 Feb 2004 14:33:35 Vince Baker replied:
In your sql, can you not just exclude all items that are = to 0?

Regards
Vince

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting
Replied 03 Mar 2004 20:19:17
03 Mar 2004 20:19:17 Alfa Siete replied:
Thank you, I did this:
IF (catalogo.Fields.Item("pmsiniva".Value) >"0" Then%>
<font color="#CC3300" face="Arial, Helvetica, sans-serif">
<b><img src="images/OFERTA.gif" width="62" height="32"></b></font><b>
<font size="2" face="Arial, Helvetica, sans-serif" color="#CC3300"></font></b></font>
<font size="3">
<%End IF%>

Everybody should belive in something... I belive i'm having another beer

Reply to this topic