Group by error:Expected end of statement

jerrold · #1 (**permalink**) 01-28-10, 02:37 AM

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>

wirehopper · #2 (**permalink**) 01-28-10, 06:49 PM

Move the quote to the end of the string.

SQL_query = "SELECT products, SUM(sales) AS Totalsales FROM Customer GROUP BY products";

jerrold · #3 (**permalink**) 01-29-10, 02:34 AM

thank wirehopper its works...

but if i write this code BAG: <%=RS("Totalsales")%> the display is
BAG: 2
BAG: 4

this is i want to be the out put
Red Bag: 2
Yellow Bag: 4
Total Bag: 6

wirehopper · #4 (**permalink**) 01-29-10, 07:26 AM

What are the other fields in your database?