I think your probem stems from using a formatted (i.e. string) value in a
mathematical evaluation. I would remove all output formatting functions
from your database formulas and apply them as needed within your templates
when displaying the values produced.
Jim
----- Original Message -----
From: "seth ward" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, October 11, 2000 12:11 PM
Subject: working with evaluate()
--------------------------------------
Problem (short description)
---------------------------------------
if I set a variable, e.g. DISCOUNT, to equal
EVALUATE(NUMBERFORMAT(ORDERTOTAL - 100000)*0.1)) how do I then
recalculate ORDERVALUE less the discount?
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.