
April 2nd, 2004, 07:00 PM
|
|
Registered User
|
|
Join Date: Mar 2004
Posts: 14
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Problems with a SELECT SUM() AS statement
When I execute the code around these statements I get the error below. Any suggestions on why or ideas about a better way to a total from a column in a dataset with 3 or 4 filter conditions will be greatly appreciated.
Select SUM(amount) AS SQLTotal FROM T1 WHERE comID = 'C1' AND catID = 'C2' AND mnth = 'March' AND yr = '2004'
LableTotal.Text = SQLTotal;
Compiler Error Message: CS0103: The name 'SQLTotal' does not exist in the class or namespace 'ASP.rptTest_aspx'
Thank you!
iRead
|