in reply to Re^6: Perl DBI execute statement
in thread Perl DBI execute statement
But unless you nest the 2 loops if this query returns multiple IDs
my $feed_table_ext_idcode = $dbh2->prepare( "SELECT id_code FROM $feed_table WHERE entry_time >= ?"); $feed_table_ext_idcode->execute($time);
then only records with the last ID will be selected/inserted in the second loop because the records with the other IDs will have been discarded in the first select loop.
pojwhile (my @row = $feed_table_ext_idcode->fetchrow_array()) { #print "@row\n"; $feed_table_ext_results->execute(@row); }
|
|---|