Yeah, good point. You're doing a LIKE anyway, it doesn't have to be the same size.
> -----Original Message----- > From: JediHomer [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 18, 2005 3:14 AM > To: CF-Talk > Subject: Re: QoQ, CFQueryParam and LIKE > > Yea basically my 'fix' is just to shrink the like part down to the > length that fits :) > > On 17/10/05, Munson, Jacob <[EMAIL PROTECTED]> wrote: > > There may be a fix for this, or maybe it's a bug. But I've > had problems > > doing QofQ before, and I normally just find a way to work around it. > > I'd split the huge amounts of text your searching for into separate > > variables or something. Or maybe figure out a way to > directly query the > > DB instead of QofQ (which is what I usually end up doing in these > > cases). SQL Server supports subqueries, as I'm sure you > know. So you > > should be able to emulate the QofQ you're trying to do by > doing a single > > query with a subquery. This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221344 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
