Hey Andrew, No problem, sorry it wasn't an easy fix.
Good luck! On Jan 15, 8:41 am, Andrew Scott <[EMAIL PROTECTED]> 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: cfaussie@googlegroups.com [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- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---