Re: Help with SQL.

["jpnd" <jpnd@xxxxxxxxx>]

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.