> I want to do a GROUP BY statement in an ASP-Page. > In CF I can do something like: > <cfoutput query="foo1" group="foo2"> > > When I try to do this in ASP included in the SQL-statement > I get an aggregate function error. > (unfortunately in german, so it doesn't make sense to post). > > Can s.o. post his ASP-Coding using group BY ?
You might get more of an answer from an ASP list, rather than a CF list... Now, if you asked if CF can do something that ASP can do, then you might get some solutions <g> The GROUP BY in SQL is a completely different beast from the GROUP in a CFOUTPUT, if you want help with that, post your SQL and we might be able to help on that... Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
