select sum() problem

[parames]

hi gang.. i want to select sum of a particular field in my tale, so my code look like this..

Set Conn = Server.CreateObject("ADODB.Connection&quot
Conn.Open "DSN=project;UID=root;pwd="

Query1 = "SELECT sum(invonhand) from store where status ='SQ' and productitem = '"& RS("productitem&quot &"'"

Set RS1= Conn.Execute(Query1)

the problem is i don't know how to output the result..
i tried this two method but cannot get the output.. it shows error message

1) response.write RS1
2) output = RS1("invonhand&quot

please help..

thanks a lot..

rgds,
parames.s

 

[mrichards]

You should name the output field in the sql.

Query1 = "SELECT sum(invonhand) as sumofinv from store where status ='SQ' and productitem = '"& RS("productitem&quot &"'"

then

response.write sumofinv

Mark