> WHERE
> (dsp_millthou='thousand' AND dsp_amount>#Int(req.fromVALUE/1000)#)
> OR
> (dsp_millthou='million' AND dsp_amount>#Int(req.fromVALUE/1000000)#)
> OR
> (dsp_millthou='billion' AND dsp_amount>#Int(req.fromVALUE/1000000000)#)
If I use a varient of this, I'm not even sure I need the CASE statement
at all...
In theory then...
Assuming
form.fromVALUE
form.toVALUE
form.fromMILLTHOU
form.toMILLTHOU
req.frommultiplier (set depending on fromMILLTHOU choice...)
req.tomultiplier (set depending on toMILLTHOU choice...)
in the Query
WHERE
(dsp_millthou = '#form.fromMILLTHOU#'
and dsp_amount > #Int(req.fromVALUE/req.frommultiplier)#)
AND
(dsp_millthou = '#form.toMILLTHOU#'
and dsp_amount > #Int(req.toVALUE/req.tomultiplier)#)
That outta work, shouldn't it?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308522
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
