Hi all
Im connecting to a MS SQL database 7.0 using
JDBC. I have to make the same query multiple times with the only change being a new "where" clause. Im trying to do this with a query that looks like this:
queryString= "select sum(ITEM) as item from database where condition1; select sum(ITEM) as item2 from database where condition2;";
and Im getting the result of the query out in to integers like this:
itemInt = rs.getInt(item);
item2Int = rs.getInt(item2);
This works fine if I only have 1 "select" query in the queryString, but when I put in the second "select" query I get an SQLException that: Column "item2" not found.
Do I have to make seperate queryStrings for each timeperiod or can it be done in one??
If you need to see the code just ask.
Regards
S�ren Augustesen
[This message has been edited by S�ren Augustesen (edited December 15, 2001).]
[This message has been edited by S�ren Augustesen (edited December 15, 2001).]