AFAIK this is a "my brain hurts" style CF error - ie CF is struggling to perform its basic functions due to too much stress or not enough resources.
Could it be that having that many LIKE statements is making the box think too hard. Try running that query through a none cf dbms interface and see how long it runs and how resource intensive it is. This depends largely on how many records you have and whther or not you have full text indexes on those fields. Cheers Mark ______________ Mark Stanton Web Production Gruden Pty Ltd Tel: 9956 6388 Mob: 0410 458 201 Fax: 9956 8433 www.gruden.com --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
