> I tend to overcomplicated things. Let's rephrase the question:
>
> For:
>
> #DollarFormat(ST_100.DIST_COST * ADJUST.ADJUST100)#
>
> How would I make the Arithmetic _expression_ "*"  a variable from
> the database, so it could be addition, subtraction, division -
> whatever was in the cell at the time?

This is what the Evaluate function is for - it allows you to build a string,
and treat that string as an _expression_:

<cfset myOperator = "*">
<cfset myResult = Evaluate(ST_100.DIST_COST & myOperator &
ADJUST.ADJUST100)>

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to