[ic] Worked in 4.8.7, No work in 4.9.6
McTees
interchange-users@icdevgroup.org
Sat Jun 21 17:12:00 2003
Im stuck.. The following coded worked fine in 4.8.6 and 4.8.7, But since we
upgraded to 4.9.6
is doesn't work anymore. I know 4.9.8 is out, and we are planning on
upgrading soon. But can
anyone see a reason why this doesn't work anymore?
[query sql="select comment, active, amount, percent, min_amount, code from
ddbc where code = '[value ec]'"
type=list
list=1]
<br>
[on_match]
[if-sql-param active]
[if term="[subtotal noformat=1]" op=">=" compare="[sql-param min_amount]"]
[if-sql-param percent]
<center><b>[sql-param comment]</b></center>
[/if-sql-param]
[if-sql-param amount]
<center><b>[sql-param comment]</b></center>
[/if-sql-param]
[else]
<center><b>Sorry, You do not meet the requirement.</b></center>
[/else]
[/if]
[else]
<center><b>Sorry, no longer active.</b></center>
[/else]
[/if-sql-param]
[/on_match]
[no_match][list][/list]
<center><b>Sorry, no match found.</b></center>
[/no_match]
[/query]
Thanks a bunch..
Michael