Setting variables Problem

[acewilli]

I am using ASP with VBScript. The code below does not work at all. What is the correct way to use an aggregate function in order to set the results of it to a variable? Please....anyone? I'm begging. I've tried everything. Thank you.

strtotal = "Select cast(sum(npoints) as decimal) from team"
Set rsTotal = Server.CreateObject("ADODB.Recordset")
rsTotal.open strtotal, db

 

[PHV]

So, you simply want rsTotal.Fields(0) ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[xwb]

Do you really need to cast as decimal?

strtotal = "Select sum(npoints) from team"

 

[acewilli]

no I do not have to cast as decimal although I don't want something such as this 10.0 I would like 10 instead. Either way though. No big deal. The problem is that when I do it the way you suggest xwb is that it just returns Select sum(npoints) from team rather than the actual SUM of that column. Not sure what is going on with it. Any other ideas? I sure do appreciate it.

Thanks,

acewilli

 

[acewilli]

PHV & XWV...here is what I finally got to work. Could either of you tell me why this would work and the other ways would not?

set rs=db.execute ("Select SUM(npoints) as strtotal from team ")

Thank you both for everything.

acewilli