I'd like to see more robust CFCASE performance: the ability to handle ranges, and
ranges+items, rather than just items. I ran into this when porting an auto insurance
rating system over to CF and this was the biggest pet peeve.
You can work around the limitation, of course, but its a lot nicer to have at your
fingertips. This simple code below (not from CF) shows what I mean. When you are
trying to test a few dozen ZIP code ranges, where any given case value could be a
range of 5, 20 or 100 sequential 5-digit numbers, then inputting a range is much
simpler to code.
No idea what it'd do to CF processing, tho' ;D
SELECT CASE r17.RT
CASE IS < 93639:r00.RT = 0.0055
CASE 93640 TO 93711,93720,93727:r00.RT = 0.00425
CASE IS > 93727:r00.RT = 0.0030
END SELECT
---------------------------------------
Matt Robertson [EMAIL PROTECTED]
MSB Designs, Inc., www.mysecretbase.com
---------------------------------------
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
