Looks like the usage of Lower() function in a query of query does not work
as in standard SQL.
Simple example: if you have a table containing names ( first_name
middle_name and last_name) the following query of query :
<cfquery name=�myquery� dbtype=�query�>
select * from myfirstquery where Lower(middle_name) like �%mat�
<cfquery>
gives the following error message:
�The system has attempted to use an undefined value, which usually indicates
a programming error, either in your code or some system code.
Null Pointers are another name for undefined values. �
In case on of the rows has no value for middle_name..
This SQL statement perfectly works in Oracle or other DB.
Dominique
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
