12 messages in com.mysql.lists.javaRe: number of rows in result set?
FromSent OnAttachments
Minh Tran08 Jan 2001 19:34 
Tim Endres08 Jan 2001 19:42 
Matt Penner09 Jan 2001 00:36 
Cato, Christopher09 Jan 2001 04:19 
Cato, Christopher09 Jan 2001 06:05 
Dror Matalon09 Jan 2001 10:45 
Minh Tran09 Jan 2001 15:33 
Tim Endres09 Jan 2001 16:01 
Dror Matalon09 Jan 2001 16:40 
Corrado Berti10 Jan 2001 16:57 
Henry Roberts11 Jan 2001 13:51 
Henry Roberts11 Jan 2001 14:00 
Subject:Re: number of rows in result set?
From:Tim Endres (ti@trustice.com)
Date:01/08/2001 07:42:14 PM
List:com.mysql.lists.java

Sorry, you must iterate to count. Your alternative is to make two calls, the first being a select ... COUNT(*), followed by the same select without the COUNT. See section 7.4.13 of the MySQL manual.

tim.

hello all,

Is there a method that will give me the number of rows in a result set? From the docs I can only see getColumnCount() in the ResultSetMetaData class, I need the equivalent for rows.

--------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail java@lists.mysql.com

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail java@lists.mysql.com instead.