Re: Help with SQL.

Ok will do.  But do I reference it by:
int x = rs.getInt(1);
?

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




"jpnd" <jpnd@xxxxxxxxx> 
Sent by: java400-l-bounces@xxxxxxxxxxxx
2005/09/13 12:14 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.






Use COUNT(*) instead of COUNT(1)



On Tue, 13 Sep 2005 12:02:08 -0230, RPower wrote
> 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
> -- 
> This is the Java Programming on and around the iSeries / AS400 
> (JAVA400-L) mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.