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 On Jan 13, 8:38 pm, "Andrew Scott" <[EMAIL PROTECTED]> wrote: > Charlie, > > Thats ok, wasn't 100% sure anyway. > > On 1/13/08, Charlie Arehart (lists account) <[EMAIL PROTECTED]> wrote: > > > > > > > > > Well, FWIW, I was just responding to Haikal's comment (and had left his > > appearing below my reply). He was replying to you, but I was referring just > > to his assertion about "Are you using SeeFusion? If you are, you should be > > able to see what the exact SQL passed to CF is." I wasn't commenting at > > all, really, on what you'd written originally. Sorry if that wasn't clear. > > > /charlie > > > -----Original Message----- > > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf > > Of Andrew Scott > > Sent: Thursday, January 10, 2008 6:30 PM > > To: cfaussie@googlegroups.com > > Subject: [cfaussie] Re: Small but large problem > > > Charlie, > > > If you are referring the FYI to me, yeah I am running this on CF8. And am > > well aware of those options, was just hoping that someone might see a > > potential problem with it. > > > Anyway good news is that the client has changed their mind on that > > component, which I think is great that component was the trickiest to > > develop in the first place. > > > Andrew Scott > > -- > > Senior Coldfusion Developer > Aegeon Pty. Ltd.www.aegeon.com.au > Phone: +613 8676 4223 > Mobile: 0404 998 273- 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 -~----------~----~----~----~------~----~------~--~---