ASP VBScript , DW8 Recordset Problem

I'm trying to create a small shopping cart site using VBscript and ASP

I’ve run into an odd problem with the following SQL:

SELECT sum(dbo.product.prodprice)

FROM dbo.cart,dbo.product

WHERE dbo.cart.username='varUsername' AND dbo.cart.prodID=dbo.product.prodID AND dbo.cart.orderID=''

This SQL is being used to return a user(s) shopping cart total; now although this works when I click the test button under advanced query, i.e. it gives the total as expected. Once I’ve pressed OK, and select the rscarttotal recordset; I am given a lighting bolt icon without any name in the data binding pane.

I am unable to drag and drop it into the table; However if I remove the sum function it gives me the prodprice data field which I can drag However this isn’t any good for me in this situation because it only returns the individual prices and not the total price of the items in the shopping cart.

Can anyone assit, many thanks

kwp243234

Try adding an Alias