> > > CFMX Query of Query has an lcase function. You could use > this to do a > > non-case sensitive type search. This function did not exist in CF5 > > QofQ however. > > LCase() throws an syntax error and is not in the docs [1], whereas > Lower() is and only throws a null exception when it gets to proces a > NULL. Although I can's seem to find either one in the BNF form [2] of > the docs, so I think some work is needed there. > > Jochem > > [1]http://livedocs.macromedia.com/cfmxdocs/Developing_ColdFusi > on_MX_Applications_with_CFML/using_recordsets4.jsp > [2]http://livedocs.macromedia.com/cfmxdocs/Developing_ColdFusi > on_MX_Applications_with_CFML/using_recordsets5.jsp
It's what I get for posting before coffee. Yes, Lower() is right, not Lcase. So the issue is that it's not handling a null value in the column? -Ray ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com