Threaded Mode | Linear Mode

programmer100 · 02-06-2010, 11:34 PM

hi...
i have an error to total my products in group by
any help please .....
this is my code what is wrong?

Code:

<BODY>

<%

 Set MyConn = Server.CreateObject("ADODB.Connection")

 MyConn.Open "FILEDSN=c:/dsn/MyTable_dsn.dsn"

 SQL_query = "SELECT products, SUM(sales) AS Totalsales"

 FROM Customer

 GROUP BY products;

 Set RS = MyConn.Execute(SQL_query)

 WHILE NOT RS.EOF

 %>

<br>

BAG: <%=RS("Total sales")%>

<br>

<%

 RS.MoveNext

 WEND

 RS.Close

 MyConn.Close

%>

</BODY>

[/php]