[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