[ic] 3AM and no hair left to pull out..

McTees interchange-users@icdevgroup.org
Sat Nov 23 03:47:00 2002


Hiya folks..

Can anyone help shed some light on why this isn't working?
Or is there some better way to do this? ( I am sure that there is a better way)

Everything works fine, till i want to check if the [subtotal] is >= to the 
min_amount.

------------------

[query sql="select comment, active, amount, percent, min_amount, code from 
coupons where code = '[value ecoupon]'" type=list list=1]
   [on_match]
   	[if [sql-param active] > 0]
    	      [if [subtotal noformat=1] >= [sql-param 
min_amount]   <---   Having trouble here....
	           [if [sql-param percent] > 0]
	                ..do something..
    	           [/if]
    	           [if [sql-param amount] > 0]
		     ... do something ...	
	           [/if]
	       [else]
	             ,,, do something ...
                  [/else]
	       [/if]
           [else]
	    ... do something ...	
	[/else]
	[/if]
    [/on_match]
    [no_match][list][/list]
        ... do something ...
    [/no_match]
[/query]

---------------

Thank you for your help and time.

Michael