Re^5: getting the name of a variable to use as string

As noted before you almost never want to do it the way you described. Hash slice syntax is what you want.

my %h;
my @cols = qw( a b c d );

@h{@cols} = split ' ', 'does this do it?';

use Data::Dumper;
print Dumper \%h;
__DATA__
$VAR1 = {
          'a' => 'does',
          'b' => 'this',
          'c' => 'do',
          'd' => 'it?'
        };
[download]

If you designed this database it is worth noting that each column in a RDBMS should be atomic ie you should not be storing pipe delimited data and then breaking it out as you loose a lot of power.

cheers

tachyon

Comment on Re^5: getting the name of a variable to use as string Download Code

Replies are listed 'Best First'.
Re^6: getting the name of a variable to use as string by pmneve (Novice) on Sep 21, 2004 at 21:33 UTC
The database itself does not contain pipe delimited data. That's the format of the unloaded flat file I'm forced (in some circumstances) to use. I often must extract data from some 500 individual databases (one per store, obviously) not particularly centralized...), transport it to a central server and process it. Not pretty, but sometimes necessary. I didn't design the database thank goodness. Thanks for your help! That snippet looks like it might help (or show me the error of my ways ;-) ) pat	[reply]

Replies are listed 'Best First'.

Re^6: getting the name of a variable to use as string
by pmneve (Novice) on Sep 21, 2004 at 21:33 UTC

I often must extract data from some 500 individual databases (one per store, obviously) not particularly centralized...), transport it to a central server and process it.

Not pretty, but sometimes necessary. I didn't design the database thank goodness.

Thanks for your help! That snippet looks like it might help (or show me the error of my ways ;-) )

pat

[reply]