> ----- Original Message ----- > From: "Steve Edberg" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Friday, June 28, 2002 1:49 PM > Subject: RE: RecordCount > > > > I assume you are using ODBC to access MySQL; I have had this problem > > before (sorry, don't remember the details...it was several years > > ago). Some ODBC drivers don't return the record count - they return > > -1 instead. You might need to update your driver. The myodbc mailing > > list might be of more help... > > > > -steve
The ADO rs.recordCount method returns the correct value only when you are using the client side cursor, but server side cursor will always return -1 as the total number of rows in the current resultset, and this is a known issue. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php