RE: Tie hashes in DBIx::Recordset [OT]
Obviously sorting the hash keys wont give you the columns
in the select statement order.
After doing something like:
my $sth = $dbh->execute(@params) or die...
You can get back the lower case column names in the select
statement order using:
my @names = @{$sth->{NAME_lc}};
Note that $sth->{NAME_lc} is not always populated, depending
upon your SQL.
Regards
Jeff
-Original Message-
From: Ged Haywood [mailto:[EMAIL PROTECTED]]
Sent: 13 March 2002 10:30
To: Marcus Claesson
Cc: [EMAIL PROTECTED]
Subject: Re: Tie hashes in DBIx::Recordset [OT]
Hi there,
On Wed, 13 Mar 2002, Marcus Claesson wrote:
> How do I succesfully preserve the column order (''$fields'=>
> $joined_col') in my array-of-hashes generated using DBIx::Recordset?
Check out a Perl tutorial or the Camel book. Perl's hashes do their own
thing with ordering, so unless you do something like (sort keys %hash)
you will get what you get. Arrays can preserve sequences but involve
you in more coding much of the time.
73,
Ged.
Re: Tie hashes in DBIx::Recordset [OT]
>Perl's hashes do their own thing with ordering, so unless you do something
like (sort keys %hash)
>you will get what you get.
Yes, but tieing the hash while creating it, in my case with Tie::IxHash,
should preserve the inesertion order.
That works with for example
tie %hash, 'Tie::IxHash';
%hash = ("one"=>"1", "two"=>"2", "three"=>"3");
But not when I create an array of hashes using DBIx::Recordset like below:
use Tie::IxHash;
use DBIx::Recordset;
...sub execute {
tie %main::set, 'Tie::IxHash';
*main::set = DBIx::Recordset->Search({('!DataSource' => $db,
'!Table' => $table,
'$fields' => $joined_col,
'$where'=> $query,
'$max' => 10)});
}
Marcus
Ged Haywood wrote:
> Hi there,
>
> On Wed, 13 Mar 2002, Marcus Claesson wrote:
>
> > How do I succesfully preserve the column order (''$fields'=>
> > $joined_col') in my array-of-hashes generated using DBIx::Recordset?
>
> Check out a Perl tutorial or the Camel book. Perl's hashes do their own
> thing with ordering, so unless you do something like (sort keys %hash)
> you will get what you get. Arrays can preserve sequences but involve
> you in more coding much of the time.
>
> 73,
> Ged.
Re: Tie hashes in DBIx::Recordset [OT]
Hi there,
On Wed, 13 Mar 2002, Marcus Claesson wrote:
> How do I succesfully preserve the column order (''$fields'=>
> $joined_col') in my array-of-hashes generated using DBIx::Recordset?
Check out a Perl tutorial or the Camel book. Perl's hashes do their own
thing with ordering, so unless you do something like (sort keys %hash)
you will get what you get. Arrays can preserve sequences but involve
you in more coding much of the time.
73,
Ged.
