Thanks brad! We use Oracle but I should be able to adapt your solution to it. I'd like to see a CF solution mainly to see the speed difference. The database solution should blow away the CF solution but I'm curious none-the-less. Maybe using your solution I can manage something like that too
On Mon, Sep 7, 2009 at 12:35 PM, <[email protected]> wrote: > > Ok Greg, I went ahead and just stuck the code and explanation into a > blog post since it was kind of long. > > http://www.codersrevolution.com/index.cfm/2009/9/7/Phone-Plan-Matchup-SQL-Brute-Force-Method > > Keep in mind this really just one way to do it, and it might not be the > best. I also considered using some recursion to generate the possible > combinations in CF, but this method was a little easier. Use it as a > starting point or don't use it at all. :) > > Thanks. > > ~Brad > > -------- Original Message -------- > Subject: Re: getting min value based on inputs > From: Greg Morphis <[email protected]> > Date: Sun, September 06, 2009 10:20 am > To: cf-talk <[email protected]> > > > The idea is that all lines add up to the total minutes entered in any > possible way because in the end they'll share the minutes. > 1 line at 10,000 minutes would fail because there are no plans of that > size. > Priority is on cost, not so much on minutes. > For example if you entered 9100 minutes and 10 lines the solution > would return 9200 minutes. > I'll have to get the exact plans/minutes on Tuesday to provide the > solution. > And if multiple options add up to the same cost then yeah, one at > random would work because it meets the requirements. > > Thanks! > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326090 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
