They use it for 100+ line accounts. Umm yeah, not going to happen. Thank for your time though Brad, good solution for learning purposes.
On Tue, Sep 8, 2009 at 10:51 AM, Greg Morphis <[email protected]> wrote: > 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:326633 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
