RE: Group Query help.

GROUP=grpQuery CFSET grpCounter = grpCounter + 1 CFIF grpCounter LTE desiredCount -Original Message- From: Nomad [mailto:[EMAIL PROTECTED] Sent: Thursday, December 15, 2005 11:49 PM To: CF-Talk Subject: Group Query help. Hello! How do I limit the number of rows returned

RE: Group Query help.

--//- -Original Message- From: Nomad [mailto:[EMAIL PROTECTED] Sent: Thursday, December 15, 2005 10:49 PM To: CF-Talk Subject: Group Query help. Hello! How do I limit the number of rows returned per group in a grouped query. My query: Select pid, Details, Brand from Products group

RE: Group Query help.

9:21 AM To: CF-Talk Subject: RE: Group Query help. I'm no SQL expert but I don't know if what you're describing is possible. Retrieve a max of 5 rows for each group in the database. I think that's going to have to be done in CF. !//-- andy matthews web developer ICGLink, Inc

Re: Group Query help.

Hi Bobby, I am using SQl Server 2000. Ben Sorry for the delay in my reply. - Original Message - From: Bobby Hartsfield [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, December 16, 2005 3:34 AM Subject: RE: Group Query help. The only thing I can think of off

Group Query help.

Hello! How do I limit the number of rows returned per group in a grouped query. My query: Select pid, Details, Brand from Products group by brand order by price This query returns: pid Details Brand 1abcdMacromedia