Problem seems to be solved. After reading through the docs i can accross http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/using_35.htm
Handling null values That did the trick. Just to note, that withoug using the fix "AND NOT NULL" that is mentioned in the docs, if i changed the LIKE "%val%" to = "val" it ran without problem. Is this a bug? There were no null values anywhere. Thanks again for your help Ricardo. On Thu, 28 Oct 2004 15:48:50 +1000, Ricardo Russon <[EMAIL PROTECTED]> wrote: > 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=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182788 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