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).]
Joined: Jan 05, 2001
You need to make separate query strings. There is a way to do multiples - you can write a stored procedure that will do the multiple SQL statements and use CallableStatement. But it looks like here you want 2 query strings.
Joined: Nov 22, 2008
Hi Jim Thanks for the quick answer, I'll give it a try. Regards S�ren Augustesen