If they are being treated by CF as strings and you want to compare them arithmetically, then wouldnt you have to make sure only the arithmetical values are compared? Something like:
val(BATCH_ITEMS.SB_FUND_PAYMENT_AMOUNT) eq (val(BATCH_ITEMS.SB_FUND_AMOUNT_ALLOCATED) + val(BATCH_ITEMS.SB_REFUND_AMOUNT))
the string 28.80 isn't equal to the string 28.8. For a start one is 4 characters long and the other is 3 characters long.
Cheers
Mike Kear
Windsor, NSW, Australia
Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
Cheers
Mike Kear
Windsor, NSW, Australia
Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
> Hi,
>
> I have a CFIF:
>
> BATCH_ITEMS.SB_FUND_PAYMENT_AMOUNT eq
> (BATCH_ITEMS.SB_FUND_AMOUNT_ALLOCATED + BATCH_ITEMS.SB_REFUND_AMOUNT)
>
> where the first number is 25.8 and the sum of the addition is 25.8
>
> yet, cfif is returning not true.
>
> Why is this so?
>
>
