Need to sum balance columns from SQL Server

Anyone have a tutorial on how to use the Repeating Region behavior (or
similar) that then also allows me to sum a given field (SQL Server to
ASP/VBScript) on the page in a "Total" column?

What you could do is create an extra recordset with some SQL like

select sum(Goals) as TotalGoals from FootyTable

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

Yeah, thats pretty much what I did.. but I wonder how I could qualify it
against a session variable or URL parameter as passed by the browser?
you know... select sum(goals) as totalgoals from footytable where U_ID =
URL param kind of a thing..

That's exactly what you'd do. You'd get the sum of all records that meet
the conditions in your WHERE clause.

See, you already knew what to do.

"_Adrian" <adrianle @comcast.net> wrote

Yeah, thats pretty much what I did.. but I wonder how I could qualify it
against a session variable or URL parameter as passed by the browser?
you know... select sum(goals) as totalgoals from footytable where U_ID =
URL param kind of a thing..

ah.. ahem.. yes, but I'm afraid I don't know the exact context... I need to
know what the context is for the WHERE clause...

Exactly as you described it.
SELECT SUM(yourColumn)
FROM yourTable
WHERE yourIDField = 'some value'

If you don't know how to use variables, set up the recordset in "simple"
mode as though you're selecting the column you want to add up, add your
where conditions, etc, then go to advanced mode and simply wrap the column
name in SUM as above. The rest will stay as is.

"_Adrian" <test (AT) test (DOT) com> wrote

ah.. ahem.. yes, but I'm afraid I don't know the exact context... I need
to
know what the context is for the WHERE clause...

Yeah, thats kind of the challenge that I've got.. is how to write the SELECT
statement in the recordset so that 'somevalue' equals the URL parameter..
maybe I'm making this more difficult than it needs to be... am uncertain at
this point!

Yup.. I was making it too difficult.. found a way to do it in the
scripting .. [sigh]
http://www.dmxzone.com/forum/topic.asp?TOPIC_ID=12410&FORUM_ID=3&CAT_ID=2&Topic _Title=Show+the+summ+of+a+Repeated+field&Forum_Tit le=Dreamweaver+UltraDev