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?
Thanks, Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:3884
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
