I am beginning to think that there is a limit in the size of the query that can be used in a QoQ? can anyone confirm this?
The server dosen't struggle at all processing it... i'm totally lost on this one. The query dosen't contain any null values and the sql can be processed, but I am still getting the same error. thanks Ricardo. On Thu, 28 Oct 2004 11:49:59 +1000, Ricardo Russon <[EMAIL PROTECTED]> wrote: > If i dump out the SQL i get the following: > > SELECT * > FROM clientlistTable > WHERE field2 LIKE "%S%" > OR field3 LIKE "%S%" > OR field16 LIKE "%S%" > ORDER BY field3 > ASC > > Because of the way that cf handles data types in QoQ's i have > converted all values to a string. This is a bitch of a workaround, but > it does work. Because of this no value in the > recordset has a null value, and they all have to be croped before use. > > I have narrowed it down to field16, but i can not see how that data is > any different to any other in the recordset. > > I will keep playing with it. > thanks for the help. > > ricardo.. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=36 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182787 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
