[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