>
> After running the following:
> ****
> *set = DBIx::Recordset->Search({%fdat,('!DataSource' => $db, '!Table'
=>
> $table, '!Fields' => $joined_col, '$where' => $query, '$max' => 15)});
>
> $DBIx::Recordset::FetchsizeWarn=0;
> my $dbh = DBI->connect('DBI:Pg:dbname=ag','nobody') or die "Couldn't
> connect to database";
> my $sth = $dbh->prepare("SELECT COUNT(*) FROM $table");
> my $rv = $sth->execute;
> print $rv,br; #Generates '1'
> $rv = $sth->rows;
> print $rv,br; #Generates '1'
Yes, because you have one result, but that is not the number of rows you
counted. The result from the count you get with
my $rec = $sth -> fetchrow_arrayref ;
my $rv = $rec -> [0] ;
> my $num = @set;
> print $num,br; #Generates '15'
This is correct, because you tell DBIx::Recordset to return 15 records max.
> ****
> I take it that my driver doesn't support $sth->rows(). Am I right?
>
No, it seems that $sth->rows is working correctly.
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
-------------------------------------------------------------
