Re: DBI execute is not failing when placeholder values are not supplied

You need to actually check the return value from the execute call to see if it failed.

...
$sth->execute( @ARGV ) 
  or die "Error executing SQL: " . $sth->errstr . "\n";
...
[download]

Another alternative would be to check if there actually are arguments in @ARGV and die with a usage message if there aren't.

die "usage: $0 [temp]\n" unless @ARGV == 1;
[download]

Comment on Re: DBI execute is not failing when placeholder values are not supplied Select or Download Code

Replies are listed 'Best First'.
Re: Re: DBI execute is not failing when placeholder values are not supplied by davorg (Chancellor) on Oct 24, 2001 at 19:37 UTC
You need to actually check the return value from the `execute` call to see if it failed. Not true when the RaiseError attribute has been set. I like your idea of checking the contents of `@ARGV` tho'. -- <http://www.dave.org.uk> "The first rule of Perl club is you don't talk about Perl club."	[reply]