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.
======================================================================= Raymond Camden, ColdFusion Jedi Master for Hire Email : [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: D. Delcomminette [mailto:dde@;ingecom.com] > Sent: Thursday, October 31, 2002 9:10 AM > To: CF-Talk > Subject: RE: CF MX Query of Query Lower() Function > > > HI, > > Thanks for your answer. However for different reason it is > not acceptable > for me to use the Lower() in the original query. So I think > in this case, I > will replace the QoQ by an Oracle view, which will do the thing ... > > Dominique > > > -----Original Message----- > From: Tim Painter [mailto:cftalk@;cfex.com] > Sent: Thursday, October 31, 2002 5:45 PM > To: CF-Talk > Subject: Re: CF MX Query of Query Lower() Function > > I believe qoq has a very limited set of functions available. > To get around > that, I set the original query to also retrieve the name in > lower case and > in my qoq, search on the lower case set field. > e.g > > <cfquery name="qry1" datasource="bar"> > Select firstname, lower(firstname) as lower_first from mytable > </cfquery> > > <cfquery name="qry2" dbtype="query"> > Select firstname from qry1 where > lower_first like '%mat' > </cfquery> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
