Hi Michael,
I may be the first and the least capable of helping, but I did not quite understand what you are trying to accomplish. Your query as is will list the results so that the records will be sorted by the group. When you say limit, can you provide a description of a results you are looking to achieve. Hopefully, I was clear in my question. Larry J. Morrow COO & CTO A-PLUS Community Solutions, Inc. Office: 678.534.8326 ext 100 Fax: 801.843.5832 Cell: 678.416.8032 www.a-plus.net Please Note: The information in this email contains privileged, confidential, and proprietary information and is otherwise protected from disclosure. If you have received this email in error, please notify A-PLUS Community Solutions, Inc. immediately by replying to this message and deleting it from your computer. Anyone other than the intended is prohibited from reading, copying, or distributing this transmission. From: [email protected] [mailto:[email protected]] On Behalf Of Michael Brown Sent: Monday, July 23, 2012 5:05 PM To: [email protected] Subject: [ACFUG Discuss] Have a question about group limits Hello fellow group members, I can't seem to get my output to limit the number of records displayed per group in the database. I using mysql with cf9. This is my query that I'm attempting to get data from. The group field is "dest". <cfquery name="GetData" datasource="xxx_mysql" > select dest, property, url_e, price, description from tableB where top10 = "1" order by dest </cfquery> Thanks! -- Michael Brown 770-605-5240 <http://singleconcepts.com/images/newlogo2011_email.jpg> Marketing Solutions with vision! http://www.singleconcepts.com ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
