I add it at the end of the query, after the ORDER BY clause. Although I have tried adding it right after the WHERE clause and just before the ORDER BY clause as well... but hard luck :)
-------------------------------------------------- From: "Claude Schneegans" <[email protected]> Sent: Monday, June 15, 2009 9:10 PM To: "cf-talk" <[email protected]> Subject: Re: Case Sensitive SQL > > >>now if I add 'GROUP BY clust' then it gives an error. > > Where do yo add the GROUP BY clause ? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323513 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
