|
Can someone tell me how I can get the COUNT of the number of rows returned by my result set? My code: getApps = conn.prepareStatement( "SELECT COUNT(1) FROM " + collectionNamePubwrk + dmd.getCatalogSeparator() + appTable + " WHERE WGSPICKD = " + selectDate); rs = getApps.executeQuery(); rs.next(); My question is how do I know how many rows were returned using the COUNT function? 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
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.