in reply to Re: Perl DBI update tables
in thread Perl DBI update tables

I meant to show that but forgot to post the info:
my $activate_info= $dbh->prepare("SELECT source_code, stream_code, cli +ent_id, name, url, status_code, stream_data, feed_db, feed_table, las +t_update, report_db, sla, exclude_request, owned, push FROM stream WH +ERE id = ?"); $activate_info->execute($client_ID);

Replies are listed 'Best First'.
Re^3: Perl DBI update tables
by huck (Prior) on Dec 07, 2016 at 04:58 UTC

    Why are you selecting (and including in the to-insert array) the 3 variables that you have already inserted constants for in the insert statement (client_id, status_code, and feed_db) ?

    as kcott has pointed out you have 12 "?" symbols, so you need 12 members in the to-insert array