Re: Perl DBI update tables

Replies are listed 'Best First'.
Re^2: Perl DBI update tables by kcott (Archbishop) on Dec 07, 2016 at 01:10 UTC
"... what is the assignment for $activate_info?" ++ That's a very valid point. In my response, I assumed that was selecting the 15 columns named in the `INSERT` statement (`source_code, ..., push`). I then removed the 3 elements from `@activate_results` for which placeholders did not exist (i.e. the indices 2, 5 & 7) creating the array slice. That could be an incorrect assumption on my part. — Ken	[reply] [d/l] [select]
Re^3: Perl DBI update tables by cbtshare (Monk) on Dec 07, 2016 at 01:17 UTC
true, but I am selecting 15 values, I am not sure where its getting 12 from	[reply]
Re^4: Perl DBI update tables by kcott (Archbishop) on Dec 07, 2016 at 02:43 UTC
You wrote: "... I am selecting 15 values, I am not sure where its getting 12 from" After I wrote: "... I assumed that was selecting the 15 columns ... I then removed the 3 elements ... for which placeholders did not exist ..." `15 - 3 = 12` [download] But you don't even need that simple arithmetic: simply count the placeholders in the `VALUES` clause of your `INSERT` statement. I suspect you're missing something very fundamental: maybe a lack of knowledge or understanding. Perhaps revisit DBI; in particular, the "Placeholders and Bind Values" section. — Ken	[reply] [d/l] [select]
Re^2: Perl DBI update tables by cbtshare (Monk) on Dec 07, 2016 at 01:16 UTC
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);` [download]	[reply] [d/l]
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	[reply]