>
> Really appreciating your help Gerald!
> After
> >my $q = new CGI ;
> >%fdat = $q -> Vars ;
> the prevnextform method now works! Although, I thought %fdat was filled
> automatically.
When you use Embperl it is filled automaticly, when you CGI.pm then it's
your part
> ...
> *set = DBIx::Recordset->Search({%fdat,('!DataSource' => $db, '!Table' =>
> $table, '$fields' => $joined_col, '$where' => $query, '$max' => 5)});
>
Try to use '!Fields' instead of '$fields', does it make any difference?
> 2) If I want to get the total number of records for a query I can make a
SELECT
>
> COUNT(*) statement without $max. But is there a more neat way to see this
in
> DBIx::Recordset?
>
If the DBD driver you are using supports it (it must support $sth -> rows),
you can set $DBIx::Recordset::FetchsizeWarn to zero and then get the number
with
$num = @set ;
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
-------------------------------------------------------------
