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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists