>
> In my perldoc DBIx::Recorset there is:
>
> *set = DBIx::Recordset -> Select (\%params, $fields, $order)
> $set -> Select (\%params, $fields, $order)
> $set -> Select ($where, $fields, $order)
> Selects records from the recordsets table(s).
> [...]
> order: comma separated list of fieldnames to sort on
>
> *set = DBIx::Recordset -> Search (\%params)
> [nothing with $order here]
>
> So the Documentation is *very* wrong. :)
No, according to that documentation your example has to be written as
*set = DBIx::Recordset->Select(
{'!DataSource' => $dsn,
'!Table' => 'config',
'!Username' => $user,
'!Password' => $pass}, undef, 'id');
again, order is the third parameter to Select and _not_ a part of the
parameter hash.
> (Yes, in the Examples Part $order is only used with Search, but i dont
> look there very often. :) )
>
It's mentioned under "Search parameters", as I wrote in my privious mail:
Search parameters
$start
First row to fetch. The row specified here will appear as index 0 in the
data array.
[..]
$order
Fieldname(s) for ordering (ORDER BY) (must be comma-separated, could
also contain USING)
Since Search (and other methods) can take the same parameters, the parameter
are grouped together in the documentation by type.
Hopefully it's more clear now
Gerald
P.S. You asked on the embperl mailing list, but answered on the modperl
list. I CC it to both...
-------------------------------------------------------------
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
-------------------------------------------------------------
