> > I'm not using *set as a glob but via "$set = DBIx::Recordset->Search"; > scalar(@$set) returns the $max not the total records. > Looking at mysql.log, DBIx::Recordset is using LIMIT 0, $max. >
Yes, that's true (I forgot about this optimizsation for mysql) > Also, I tried using MoreRecords(). > The docs say it does not change the current record, but looks like it > does. The first record is gone. The first one is a little special, you can add a Reset and it will work: >All I'm doing is: > > [- $set = DBIx::Recordset->Search($h); -] > [$ if $set && $$set->MoreRecords() $] [- $$set -> Reset -] > [$ while ( my $rec = $$set->Next() ) $] > [# do stuff with $rec #] > [$ endwhile $] > [$ endif $] > Gerald ------------------------------------------------------------- Gerald Richter ecos electronic communication services gmbh Internetconnect * Webserver/-design/-datenbanken * Consulting Post: Tulpenstrasse 5 D-55276 Dienheim b. Mainz E-Mail: [EMAIL PROTECTED] Voice: +49 6133 925131 WWW: http://www.ecos.de Fax: +49 6133 925152 ------------------------------------------------------------- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
