That worked. Thanks Barney. Mark -----Original Message----- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Thursday, March 17, 2005 10:26 PM To: CF-Talk Subject: Re: Query problem
Whoops. Try this one. Meant 'group by' but typed 'order by'. Sorry about that. SELECT memberID, MAX(paidThru) AS paidThru FROM someTableName GROUP BY memberID cheers, barneyb On Thu, 17 Mar 2005 22:22:41 -0500, Mark Leder <[EMAIL PROTECTED]> wrote: > Tried it, here's the error: > > [Macromedia][SQLServer JDBC Driver][SQLServer]Column > 'someTableName.memberID' is invalid in the select list > because it is not contained in an aggregate function and there is no GROUP BY clause. > > Mark -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199285 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
