Also, <49 = white and >50 gets you pink, but 50 will get you nothing at all and the same goes for 100, 200...
--Ferg Josh Nathanson wrote: > In the orange, red, and brick cases, you have >300 <299, >400 <399, and > >500<499, which leaves no possibility for values. You need to bump up each > of those less than values by 100. I'm sure it was just a typo on your part. > > -- Josh > > > ----- Original Message ----- > From: "Andy Matthews" <[EMAIL PROTECTED]> > To: "CF-Talk" <[email protected]> > Sent: Thursday, June 01, 2006 11:05 AM > Subject: mySQLxCase statement: where value in range > > > >> I've got a table with around 40000 records. There's a column called v_pop >> with a range of 2 - 1000. I'd like to color code some HTML but use the >> query >> to do that work. So check out the code below. It runs just fine, with no >> errors, BUT, it only returns white and pink as the class, even though I >> know >> for a fact that there are records with higher values. What am I doing >> wrong >> here? >> >> I'm running mySQL 4.1.17 >> >> SELECT v_player, >> CASE >> WHEN v_pop < 49 THEN 'white' >> WHEN v_pop > 50 < 99 THEN 'pink' >> WHEN v_pop > 100 < 199 THEN 'salmon' >> WHEN v_pop > 200 < 299 THEN 'yellow' >> WHEN v_pop > 300 < 299 THEN 'orange' >> WHEN v_pop > 400 < 399 THEN 'red' >> WHEN v_pop > 500 < 499 THEN 'brick' >> END AS class >> FROM x_world >> >> <!----------------//------ >> andy matthews >> web developer >> certified advanced coldfusion programmer >> ICGLink, Inc. >> [EMAIL PROTECTED] >> 615.370.1530 x737 >> --------------//---------> >> >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241941 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
