np - I agree that sometimes you have to use the hard/difficult solution because it is the best solution for performance or technical reasons. I just wanted to raise the point that there are sometimes also good reasons not to.
Cool as... B) Andrew Scott wrote: > Brett, > > Agreed, but for the calculations that this section does there was no other > way. And you are going to have to trust me on that one. > > > Andrew Scott > Senior Coldfusion Developer > Aegeon Pty. Ltd. > www.aegeon.com.au > Phone: +613 9015 8628 > Mobile: 0404 998 273 > > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of Brett Payne-Rhodes > Sent: Tuesday, 15 January 2008 10:30 AM > To: [email protected] > Subject: [cfaussie] Re: Small but large problem > > > I feel compelled to speak up here for the "cheats way out", of which I am > often a very big fan. The main reason being that I usually try to think > about the person who is going to be coming along later to modify my code to > do something 'extra'. I mean there are some clever people on this list and I > don't consider myself in the same class, but I figure the person who comes > along to maintain my code may not even be as clever as me, and if it took me > hours and hours and multiple posts to cfaussie to work that tricky bit of > logic into one massive SQL statement or regex or whatever, then what chance > have they got!?! Sure, the intellectual challenge is what we crave, tricky > solutions to difficult problems, but in my view they're often going to cause > more problems later then they are worth. > > Just my 2c worth. > > Brett > B) > > > Andrew Scott wrote: >> Hey Chris, >> >> It is the problem, but it is a complex problem. There will either be a >> pickup city or not, and it's when there is not that is the problem. > Because >> it duplicates the records for each pickup city, hence multiplying the > total >> cost of the car hire for each city found. >> >> This is one mother of a SP, and I was hoping that there was a way to just >> modify the query on the fly. I know I could take the cheats way out and > have >> 3 different queries, but that is not an ideal situation I would like to > have >> to enter. >> >> Anyway as I stated earlier the client doesn't use that component much and >> has halted work on it. Still I feel compelled to look at it for future >> reference in my spare time, who knows when something similar might crop > up. >> >> Andrew Scott >> Senior Coldfusion Developer >> Aegeon Pty. Ltd. >> www.aegeon.com.au >> Phone: +613 9015 8628 >> Mobile: 0404 998 273 >> >> >> >> -----Original Message----- >> From: [email protected] [mailto:[EMAIL PROTECTED] On > Behalf >> Of Chris Ellem >> Sent: Tuesday, 15 January 2008 9:28 AM >> To: cfaussie >> Subject: [cfaussie] Re: Small but large problem >> >> >> Andrew, >> >> Just an idea but if the like clause is the problem, you could replace >> it. >> Modify your text entry input field with a drop down on the form. >> I assume you know every pick up and drop down location and it wouldn't >> be to big a list from a UI perspective. >> >> Maybe an option. >> >> Regards >> >> Chris Ellem >> CEO - Flex Software International Pty Ltd >> >> >> >> > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
