Re: execute failed: called with 2 bind variables when 0 are needed

in reply to execute failed: called with 2 bind variables when 0 are needed

To put it another way, change $sth->execute(1, 10); to $sth->execute(); and your SQL statement will run as is (assuming your database has the queried table and fields).

Comment on Re: execute failed: called with 2 bind variables when 0 are needed Select or Download Code

Replies are listed 'Best First'.
Re^2: execute failed: called with 2 bind variables when 0 are needed by afoken (Chancellor) on Dec 11, 2013 at 19:54 UTC
change `$sth->execute(1, 10);` to `$sth->execute();` Please don't. Placeholders prevent SQL injections and allow caching of prepared statements, so: Change the value `"E"` in `$sql` to a single, unquoted `?` Change the execute parameters to `("E")` More information: DBI, Bobby Tables, Re: Counting rows Sqlite, Re^2: Massive Memory Leak, Re^5: Variable interpolation in a file to be read in. Alexander -- Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^2: execute failed: called with 2 bind variables when 0 are needed
by afoken (Chancellor) on Dec 11, 2013 at 19:54 UTC

change $sth->execute(1, 10); to $sth->execute();

Please don't. Placeholders prevent SQL injections and allow caching of prepared statements, so:

Change the value "E" in $sql to a single, unquoted ?
Change the execute parameters to ("E")

More information: DBI, Bobby Tables, Re: Counting rows Sqlite, Re^2: Massive Memory Leak, Re^5: Variable interpolation in a file to be read in.

Alexander

--
Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)

[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom