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


Clear questions and runnable code get the best and fastest answer
	PerlMonks

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

by ig (Vicar)

on Dec 11, 2013 at 00:49 UTC ( #1066532=note: print w/replies, xml )

Need Help??

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]

In Section Seekers of Perl Wisdom

Domain Nodelet^?

www.com | www.net | www.org

Node Status^?

node history
Node Type: note [id://1066532]
help

Chatterbox^?

How do I use this? | Other CB clients

Other Users^?

Others browsing the Monastery: (5)

As of 2023-05-30 16:37 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

No recent polls found

Notices^?