I'm stuck trying to capture the output of the SUM SQL command. I have a table called Coins with columns Type, and Value. The exercise asks us to (among other things) use the 'SUM' SQL command to get the sum of the Values column. Here is the section of code that is giving me trouble.
The SimpleDataSource class just provides a convienent method for establishing a connection to the database. I know there is data in the database because the rest of my queries return predictable results. If needed, I could attach my source code. I would be greatful for any tips you can provide.
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them. - Laurence J. Peter