DDE wrote: > 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..
Seeing the same behaviour here. The issue is with the Lower function, not with the LIKE. http://www.macromedia.com/support/email/wishform/?6213=3 In the mean time, considering that any LIKE predicate on a NULL field returns false anyway, you can easily filter it out by doing an extra QofQ in between which throws out all the fields with a NULL. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
