in reply to $sth->execute problem
Your second SQL statement takes no parameters but you are passing an argument to execute(). execute() attempts to bind its arguments to query parameters. Since the second statement doesn't have any, you get this error. You aren't gaining anything by trying to execute your statements in a loop so don't do it that way.
Why are you embedding some values in the SQL string and using parameters for others? You should use parameters for all of your values. That way you won't have to worry about quoting.
--- print map { my ($m)=1<<hex($_)&11?' ':''; $m.=substr('AHJPacehklnorstu',hex($_),1) } split //,'2fde0abe76c36c914586c';
|
|---|