Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot

Re^3: If condition

by davorg (Chancellor)
on Jul 14, 2009 at 11:58 UTC ( #779887=note: print w/replies, xml ) Need Help??

in reply to Re^2: If condition
in thread If condition

When I print $data_pair->{'key'} gives me all the keys present in the array
When I print $data_pair->{'values'} gives me all the values for the keys

Your data structure is strange :-)

I think you need something like this:

my ($cor, $date); for my $data_pair (@data_list) { if ($data_pair->{key} eq 'correct') { $cor = $data_pair->{value}; } if ($data_pair->{key} eq 'date') { $date = $data_pair->{value}; } } $sql_content .= qq( INSERT IGNORE INTO correct SET text="$cor", date="$date");

But as others have already mentioned, using DBI placeholders makes far more sense here.


See the Copyright notice on my home node.

Perl training courses

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://779887]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (11)
As of 2018-06-19 16:15 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (114 votes). Check out past polls.