Has anyone had any luck using the "like" condition in a query of queries where
clause? We're still using MX6.1, so I'm hoping it may work in MX7. Here's the
code I'm executing:
select ID as id
from GetAllPubs
where LOWER(Title) like '%#LCase(arguments.searchTerms)#' or
LOWER(Abstract) like '%#LCase(arguments.searchTerms)#'
This is in a cfquery tag pair, where GetAllPubs was the original query and
dbtype is set to "query" (that is, this is a query of queries). Every time I
try to run this in my CFC, it barfs, saying that the "system has attempted to
use an undefined value". Even very simplified "like" conditions (without all of
the LOWER and LCase jazz fail with the same error.
This appears to be a bug in CF 6.1 on Linux. Anyone have similar problems? Any
solutions?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:14:3883
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/14
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:14
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.14
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
