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:221226 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
