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. > > > -----Original Message----- > > From: JediHomer [mailto:[EMAIL PROTECTED] > > Sent: Monday, October 17, 2005 10:49 AM > > To: CF-Talk > > Subject: Re: QoQ, CFQueryParam and LIKE > > > > Yep, tried cf_sql_longvarchar, cf_sql_varchar and without specifying > > the SQLType... > > > > Taking out the % then I can make the number go to 199, with > > 200 breaking it. > > > > This is happening on our CF 7 (running Win 2000) and CF 6.1 > > (running Linux) > > > > > > > > On 17/10/05, Munson, Jacob <[EMAIL PROTECTED]> wrote: > > > Did you try cfsqltype="cf_sql_longvarchar" instead of > > cf_sql_varchar? > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221311 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
