perl-embperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gerald Richter" <rich...@ecos.de>
Subject Re: DBIx::Recordset 0.24 issues
Date Tue, 29 Oct 2002 06:47:58 GMT
> 
> 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:     richter@ecos.de         Voice:    +49 6133 925131
WWW:        http://www.ecos.de      Fax:      +49 6133 925152
-------------------------------------------------------------




---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org


Mime
View raw message