RE: help with sql query/CF

2001-01-26 Thread Christoph Schmitz
Hi, SELECT DISTINCT fruit, count(fruit) AS fruitcount FROM greengrocer GROUP BY fruit ORDER BY fruit HTH, Chris --Original Message-- From: "chad jackson" [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: January 25, 2001 11:39:49 PM GMT Subject: help with sql query/CF Hi, I

RE: help with sql query/CF

2001-01-26 Thread Russel Madere
Try: SELECT fruit, COUNT(fruit) AS NumFruits FROM greengrocer GROUP BY fruit ORDER BY fruit Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the

RE: help with sql query/CF

2001-01-25 Thread John Anderson
Select fruit,count(fruit) From greengrocer Group By fruit John Anderson http://www.aloha-webdesign.com -Original Message- From: chad jackson [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 3:40 PM To: CF-Talk Subject: help with sql query/CF Hi, I have a standard query