[ic] Worked in 4.8.7, No work in 4.9.6
Paul Jordan
interchange-users@icdevgroup.org
Sat Jun 21 17:42:01 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]
I don't see how that was working in the first place.
[query......]
[on_match]
things were found... see below
[/on_match]
[list]
your ITL code here
[/list]
[no_match]
nothing was found
[/no_match]
[/query]
Paul