Calculate Sum In ASP Classic

[anon1971]

Below is the code and I recieve no errors but it write mo data in the response.write?

set rs = Server.CreateObject ("ADODB.Recordset")
Set conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionString = "Provider=SQLOLEDB;Server=SERVER\SQLEXPRESS;Database=GE_Data;Trusted_Connection=yes;"
Conn.Open

sql = "SELECT Sum(Cost)-Sum(Credit) AS SumCx FROM [LedgerD] Where [LedgerD].[ProjectID]=" & strProjectID & " And [LedgerD].[MethodID] = " & 1 & ""
rs.open sql, conn, 3, 3

Response.Write(SumCx)

 

[ChrisHirst]

SumCx is a value only in the recordset the ASP script doesn't 'know' it exists.

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

 

[xwb]

In programming terminology

Response.Write(rs("SumCx"))

If you have Option explicit in your code, it would have spotted that SumCx was not declared.

 

[anon1971]

Thanks guys works perfect with ether of xwb fixes