|
Excellent thank you. Ron Power Programmer Information Services City Of St. John's, NL P.O. Box 908 St. John's, NL A1C 5M2 709-576-8132 rpower@xxxxxxxxxx http://www.stjohns.ca/ ___________________________________________________________________________ Success is going from failure to failure without a loss of enthusiasm. - Sir Winston Churchill "Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx> Sent by: java400-l-bounces@xxxxxxxxxxxx 2005/09/13 12:32 PM Please respond to Java Programming on and around the iSeries / AS400 <java400-l@xxxxxxxxxxxx> To "'Java Programming on and around the iSeries / AS400'" <java400-l@xxxxxxxxxxxx> cc Subject RE: Help with SQL. You have defined a statement that generates a single value because you're using a group function (COUNT) and you don't have any GROUP BY statements. Because of this, only one row is returned in the result set, so do a single rs.next to position to that row. You have only specified a single numeric column, so rs.getInt(1) will retrieve that value. You could also name the field using "AS" in your SQL statement and get the value that way. Joe > From: RPower@xxxxxxxxxx > > Ok will do. But do I reference it by: > int x = rs.getInt(1);
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.