Re: Date Range Search Problem - when it's integers stored and not dates - IDEA!!!

2008-03-25 Thread denstar
On Mon, Mar 24, 2008 at 7:26 PM, Les Mizzell [EMAIL PROTECTED] wrote: ... What's the easiest way to search for values in a list starting at position X and ending at position Y? Off the top of my head, I'd do a listSort, and then iterate. Dunno if the list position idea would work for the

Re: Date Range Search Problem - when it's integers stored and not dates - IDEA!!!

2008-03-24 Thread Les Mizzell
Ahhh- here's an idea! OK, in theory... Let's just look at just the month for starters... form.startMONTH form.endMONTH Each has a value of 1 - 12 but, let's use that as LIST START AND END POSITIONS Set a list containing 2 years worth of months: cfset findMONTHS =