Re^3: Perl DBI update tables

Replies are listed 'Best First'.
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]

Replies are listed 'Best First'.

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]