House of Fusion
Search over 2,500 ColdFusion resources here
  
Home of the ColdFusion Community

Mailing Lists 		Home /  Groups /  ColdFusion Talk (CF-Talk)

[OT] SQL help

  << Previous Post |  RSS |  Tree View |  Sort Oldest First |  Subscribe to this Group Next >> 

[OT] SQL help

Thnx Matthew Spectrum Web 05/27/2004 11:11 AM
You are welcome..... ;-) John Stanley 05/27/2004 08:23 AM
Thanks :) Monique Boea 05/27/2004 08:19 AM
> From: Monique Boea Philip Arnold 05/27/2004 08:17 AM
Off Topic John Stanley 05/27/2004 08:15 AM
what is OT? Monique Boea 05/27/2004 08:14 AM
Try this (where age is the formula you're already using). I'd recommend Matthew Walker 05/25/2004 09:38 PM
Hi Spectrum WebDesign 05/25/2004 05:56 PM

05/27/2004 11:11 AM
Author: Spectrum Web Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:32777#164639 Thnx Matthew works great.... brilliant! Success! ----- Excess quoted text cut - see Original Post for more -----
05/27/2004 08:23 AM
Author: John Stanley Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:32777#164611 You are welcome..... ;-) Thanks :) Off Topic what is OT? Hi I have an table were our client save your dob(mm/dd/yyyy) in My$QL DB. By now I need to aggrupate that table queries like this: Group 1: <= 16 years Group 2: >=17 E <= 25 Group 3: >=26 E <= 40 Group 4: >=41 years My$SQL give the ages but how to aggrupate in that groups? Thanx for your time. -- ___________________________________________________________ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm   _____   _____   _____   _____  
05/27/2004 08:19 AM
Author: Monique Boea Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:32777#164610 Thanks :) Off Topic what is OT? Hi I have an table were our client save your dob(mm/dd/yyyy) in My$QL DB. By now I need to aggrupate that table queries like this: Group 1: <= 16 years Group 2: >=17 E <= 25 Group 3: >=26 E <= 40 Group 4: >=41 years My$SQL give the ages but how to aggrupate in that groups? Thanx for your time. -- ___________________________________________________________ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm   _____   _____   _____  
05/27/2004 08:17 AM
Author: Philip Arnold Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:32777#164609 > From: Monique Boea > > what is OT? Off Topic
05/27/2004 08:15 AM
Author: John Stanley Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:32777#164608 Off Topic what is OT? Hi I have an table were our client save your dob(mm/dd/yyyy) in My$QL DB. By now I need to aggrupate that table queries like this: Group 1: <= 16 years Group 2: >=17 E <= 25 Group 3: >=26 E <= 40 Group 4: >=41 years My$SQL give the ages but how to aggrupate in that groups? Thanx for your time. -- ___________________________________________________________ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm   _____   _____  
05/27/2004 08:14 AM
Author: Monique Boea Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:32777#164607 what is OT? Hi I have an table were our client save your dob(mm/dd/yyyy) in My$QL DB. By now I need to aggrupate that table queries like this: Group 1: <= 16 years Group 2: >=17 E <= 25 Group 3: >=26 E <= 40 Group 4: >=41 years My$SQL give the ages but how to aggrupate in that groups? Thanx for your time. -- ___________________________________________________________ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm   _____  
05/25/2004 09:38 PM
Author: Matthew Walker Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:32777#164389 Try this (where age is the formula you're already using). I'd recommend making a view that has the age as one of the columns. SELECT CASE   WHEN age <= 16 THEN 1        WHEN age BETWEEN 17 AND 25 THEN 2        WHEN age BETWEEN 26 AND 40 THEN 3        ELSE 4 END  AS [group] ________________________________________ Sent: Wednesday, 26 May 2004 8:22 a.m. To: CF-Talk Subject: [OT] SQL help Hi I have an table were our client save your dob(mm/dd/yyyy) in My$QL DB. By now I need to aggrupate that table queries like this: Group 1: <= 16 years Group 2: >=17 E <= 25 Group 3: >=26 E <= 40 Group 4: >=41 years My$SQL give the ages but how to aggrupate in that groups? Thanx for your time. -- ___________________________________________________________ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm ________________________________________
05/25/2004 05:56 PM
Author: Spectrum WebDesign Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:32777#164381 Hi I have an table were our client save your dob(mm/dd/yyyy) in My$QL DB. By now I need to aggrupate that table queries like this: Group 1: <= 16 years Group 2: >=17 E <= 25 Group 3: >=26 E <= 40 Group 4: >=41 years My$SQL give the ages but how to aggrupate in that groups? Thanx for your time. -- ___________________________________________________________ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm
<< Previous Thread Today's Threads Next Thread >>

Search cf-talk

May 24, 2012

<<   <   Today   >   >>
Su Mo Tu We Th Fr Sa
     1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31     

Designer, Developer and mobile workflow conference

Latest Fusion Authority Articles

Designer, Developer and mobile workflow conference

Want a number like 800-ColdFusion?

My Toll Free 800 Number provides a vanity phone number service to clients who want more than just digits. How would you like 800-coldfusion?

www.MyTollFree800Number.com