Script ASP - Database: Sum - Morpheusweb.it - Webmaster resources: programming, asp script, using asp, file asp, asp, asp post, database asp, asp login, vb asp, asp access, asp download, asp script, formmail, area riservata, paginazione, scripts asp, mailform, asp script download

ABOUT >
WORKS >
CONTACT ME >
>

Home Page
> Script ASP
> Script ASP Database
> Sum

Sum

Compute the sum of a table fields.



					
					<% 

					Dim cn,cm 

					Set cn = Server.CreateObject("ADODB.Connection") 

					cn.Open "driver={Microsoft Access Driver (*.mdb)};dbq="& Server.MapPath("Archive.mdb") 

					set rs=cn.execute ("Select SUM(costs) as mySum from [Table] ") 

					response.write "The sum is : "&rs("mySum") 

					cn.close 

					Set cn = NOTHING 

					Set rs = Nothing 

					%>