OT: RE: ASP and GROUP BY problem

ASP does not provide a "Group By" equivalent to what is available in CF. You'll need to either build a VBScript function to do this or build it each time, storing the last value of the "Grouped" attribute and executing a sequence of code when it changes. Then your query would ORDER BY your groupe

RE: ASP and GROUP BY problem

> I want to do a GROUP BY statement in an ASP-Page. > In CF I can do something like: > > > 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