This little gem goes down as another of those "I've been using CF this long and never knew this important thing" scenarios.
When you're performing a query-of-query and using a LIKE operator, the match becomes case sensitive.ﾠ Here's an example.ﾠ Let's say you have a table, "chores" with these records in it (one column):
| ID | NAME |
|---|---|
| 1 | Wash the dishes |
| 2 | Start the washing machine |
| 3 | Dish out some justice |
| 4 | Play golf |
First start with a standard select out of the database.ﾠ Of course, this doesn't make sense, it's just for the example.
Now we'll select from that query (the famous query-of-query) but use the LIKE operator.ﾠ The objective is to get all the records with some variation of "wash" in them.ﾠ We expect to see records with ID 1 and 2, however, the following will only yield ID 2:
<cfquery name="qChores" dbtype="query">
SELECT ID, name
FROM qOriginalQuery
WHERE (name LIKE '%wash%')
</cfquery>
In order to retrieve records with ID 1 and 2, as you might have wanted, you can force everything to upper case to eliminate any value differences:
<cfquery name="qChores" dbtype="query">
SELECT ID, name
FROM qOriginalQuery
WHERE (UPPER(name) LIKE '%#UCase(wash)#%')
</cfquery>
Credit for this answer to my frustrations goes to my Google result, Just Skins.ﾠ Thanks!
Mar 5, 2010 at 2:17 AM so good.genuine <a href="www.vipuggstores.com/">ugg boots</a> range for 2010.many ugg boots at great prices.huge range,all with fast.
Mar 5, 2010 at 2:18 AM so nice .online <a href="www.chiflatiron4u.com/">chi hair iron</a> shop provide kinds of chi stylers.chi purple hair straightener.
Mar 5, 2010 at 2:22 AM well,nice post.whatever your hair tpye is,<a href="www.topghdmart.com/">ghd hair straightener</a> protects your hair while styling.enjoy the free shipping.
Mar 5, 2010 at 4:03 AM <body>
There are different types of straightening iron hair stylers available out there in the market for sale<a href="http://www.ghdhaironstyler.com/dark-ghd-iv-styler-p-13178.html?cPath=482">; ghd iv dark styler</a>. Those available in the GHD range are unquestionably <a href="http://www.ghdhaironstyler.com/chi-blue-camo-ceramic-flat-iron-p-13172.html?cPath=476">ghd purple styling set</a> the best hair straighteners. They have emerged as the staple of the beauty market because of the tremendous features and amazing results that they have to offer<a href="http://www.ghdhaironstyler.com/chi-camo-green-ceramic-flat-iron-p-13174.html?cPath=478">; ghd hot pink styler</a>. The best thing about them is that they are not only easy to use, but they are also incredibly reliable. Unlike other models, they rarely fail. They can straighten your hair in a significantly lesser time because they work at quite a hot level. <a href="http://www.ghdhaironstyler.com/chi-pink-ceramic-flat-iron-p-13176.html?cPath=480">chi flat iron </a> Interestingly, they also cool down very quickly. Quick heat up<a href="http://www.ghdhaironstyler.com/chi-red-hair-straightener-p-13177.html?cPath=481">ghd iv kiss styler</a> is another great feature<a href="http://www.ghdhaironstyler.com/chi-red-hair-straightener-p-13177.html?cPath=481">ghd iv ceramic hair straightener </a> of GHD hair straighteners. Once you plug it and switch it on, it can heat up in a very short time, providing you more time to do your hair. Because of all these wonderful benefits, hair <a href="http://www.ghdhaironstyler.com/pure-ghd-iv-styler-p-13183.html?cPath=487">ghd iv pure styler</a> salons all over the world use GHD stylers. However, there are different types of products available in this range. Following is a brief rundown on how to choose the most suitable one for you.<a href="http://www.ghdhaironstyler.com">http://www.ghdhaironstyler.com/
</a>
</body>
</html>
Mar 5, 2010 at 4:03 AM <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">;
<html xmlns="http://www.w3.org/1999/xhtml">;
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>￠ﾘﾇc</title>
</head>
<body>
<p>Once again, it's a pretty slow day for Met news. The most interesting story out there is Murray Chass's post on Omar's inability to multi-task this offseason. While I really despise anonymous sources, this does sound so stupid that it's probably true.</p>
<p>Nelson Figueroa threw a complete game three-hitter in the Dominican Republic.Ted Berg has some great Val Pascucci video.For those Mets fans with more high brow tastes, <a href="http://www.nhlbuy.com/nfl-jersey-c-1.html?zenid=d5d388d6cbca033a03aa0ffd7bc10cf2">cheap nfl jersey</a>be sure to check out the Met poetry <a href="http://www.nhlbuy.com/nba-jersey-c-51.html">cheap adidas nba jerseys</a>reading on Feb. 16.</p>
<p>Bobby Valentine will serve on a commission to improve Stamford's fire department. I hope for Stamford's sake that the solution will not involve Armando Benitez.Teddy Dziuba sat down with Met<a href="http://www.nhlbuy.com/mlb-jersey-c-34.html">discount mlb jersey</a> prospect Shawn Bowman who was recently<a href="http://www.nhlbuy.com/nba-jersey-c-51.html">cheap nba jersey</a> added to the Met 40 man roster.Around the NL EastThere is a really great Philadelphia joke in<a href="http://www.nhlbuy.com/nfl-jersey-c-1.html?zenid=d5d388d6cbca033a03aa0ffd7bc10cf2">wholesale football jersey</a> here somewhere, but I'm both too politically correct and not a <a href="http://www.nhlbuy.com/nhl-jersey-c-71.html">cheap nhl replica jersey</a>good enough joke writer to make it.Washington has signed Adam Kennedy, right after the O-Dog signed <a href="http://www.nhlbuy.com/nfl-jersey-c-1.html?zenid=d5d388d6cbca033a03aa0ffd7bc10cf2">new orleans saints jersey</a>with Minnesota. That means, once again, the Mets are stuck with Luis Castillo.<a href="http://www.nhlbuy.com/">http://www.nhlbuy.com/</a></p>;
</body>
</html>
Mar 5, 2010 at 9:25 PM [url=http://www.mbt-lami.com/]Mbt shoes[/url]sport white and [url=http://www.mbt-lami.com/mbt-chapa-c-4.html]Mbt chapa shoes[/url] are first choice for the [url=http://www.mbt-lami.com/]Mbt [/url] [url=http://www.mbt-lami.com/]Mbt shoes sale[/url]
Mar 6, 2010 at 12:22 AM 2010 Latest Designer True Religion Jeans
Seven jeans with 59% Discount
Seven for mankind Promotion Now on jeans-classic. http://www.jeans-classic.com
Mar 7, 2010 at 9:14 PM <a href="http://www.sharembt.com/mbt-changa-shoes-c-242.html">Mbt changa shoes</a> can help control weight, eliminating also believe and neck pain, injury, lazy. <a href="http://www.sharembt.com/mbt-lami-shoes-c-237.html">Mbt lami sale </a>manufacturers are also guaranteed main battle tanks will increase the wearer's posture and cheap.<a href="http://www.sharembt.com/mbt-womens-mwalk-c-1.html">mbt m walk shoe</a> tone muscles to help them.
Mar 7, 2010 at 9:20 PM I got one pair of <a href="http://www.sellmbt.com/womens-mwalk-shoes-c-237.html">mbt m walk shoe </a>from Kicksin. Love my MBT! I have flat feet and often find it difficult to find comfortable <a href="http://www.sellmbt.com/womens-chapa-shoes-c-239.html">mbt chapa shoes </a>...that is until I discovered <a href="http://www.sellmbt.com/mbt-lami-shoes-c-238.html">mbt lami shoes</a>!
Mar 7, 2010 at 9:34 PM good!
Mar 8, 2010 at 2:02 AM lighting designer Adam Silverman. Paul Steinberg's corrugated metal sets are fine, <a href="http://www.kicksorder.com"; title="wholesale jordan shoes">wholesale jordan shoes</a> even though the first act <a href="http://www.jordan23jordan.com"; title="wholesale jordan shoes">wholesale jordan shoes</a> looks an awful lot like the first act set for Alden's recent <a href="http://www.ebaykicks.com/"; title="wholesale nike shoes">wholesale nike shoes</a> ENO Jenfa. <a href="http://www.discountjordanshoes.com"; title="wholesale jordan shoes">wholesale jordan shoes</a> Grime's precariously perched, too tidy hut is particularly handsome, and the act two beach scene <a href="http://www.heykicks.com"; title="wholesale jordan shoes">wholesale jordan shoes</a> is beautiful in <a href="http://www.kicksfly.com"; title="wholesale jordan shoes">wholesale jordan shoes</a> an Edward Hopperish fashion
Mar 8, 2010 at 2:13 AM Very good posting. I just love it.
Good luck man with your work
<a href= http://www.airmax-shox.com/en/category/7-air-max-90.html >air max shoes</a>
Mar 9, 2010 at 1:34 AM mbt shoes made from high quality Nappa leather are strong and enduring.mbt shoes Best Prices available at cheap mbt shoes help to build body
Mar 9, 2010 at 1:43 AM know, We would say with still redden family link of london. Because jewelries, we could be better to go notion clothes with a will that everything is OK for <a href="http://www.linksoflondon.me/links-of-london-necklace-show-your-taste-2/">links of london</a> me excluding relations of london! Want to help you! Keep
Mar 9, 2010 at 4:08 AM <a href="http://www.baidu.com">~ﾦ</a>;
[url=http://www.sina.com]sina[/url]
[url="http://www.baidu.com";]baidu[/url]
[url=www.google.com]google[/url]
[link=http://www.yahoo.com]yahoo[/link]
[a/]http://www.yahoo.com[a]yahoo[/a]
Mar 9, 2010 at 4:10 AM Your idea is novel,I like it,Thank you for sharing.
Mar 9, 2010 at 8:36 PM well,so good .do you know what makes the [url=www.chiflatiron4u.com]chi flat iron[/url] so special?why are so many women so interested in styling their hair
with a chi hair straightener ?
Mar 9, 2010 at 8:39 PM so nice post ,the [url=www.topghdmart.com]ghd hair straightener[/url] are worth every penny.buy cheap ghd hair straightener in my stores ,ghd irons and ghd hair straightener.
Mar 9, 2010 at 8:41 PM yes,you are right.[url=http://www.vipuggstores.com/]ugg boots[/url] on sale,million of cheap uk ugg boots ,ugg sheepskin boots,ugg
cardy boots,ugg kid boots ,ugg classic tall boots,etc.
Mar 10, 2010 at 9:34 PM All people deserve good life time and <a href="http://lowest-rate-loans.com/topics/business-loans">business loans</a> or just short term loan would make it better. Because freedom is based on money.