Your skill will accomplish what the force of many cannot |
|
PerlMonks |
Re: $hour_insert_sth->execute showing errorby 1nickt (Canon) |
on Nov 04, 2015 at 07:16 UTC ( [id://1146874]=note: print w/replies, xml ) | Need Help?? |
Hi ravi45722, Yes, this is a not very informative message from MySQL. You can help by placing in your script; this will print out a lot of information including the actual SQL passed to MySQL, which will probably help you spot your problem. See DBI TRACING. Your error is probably not caused by the string value in $system_id: your use of placeholders makes quoting the values you are going to pass to the DBI unnecessary. Also note that since you are passing the RaiseError attribute you don't need the or die $DBI::errstr after your calls to your DBI methods. Hope this helps!
The way forward always starts with a minimal test.
In Section
Seekers of Perl Wisdom
|
|