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 -~----------~----~----~----~------~----~------~--~---
