Re: DBI::mysql fetch() without execute() PROBLEM

Since the error points to line 20, try replacing that line with this :

die  $dbh->errstr if $dbh->errstr;
[download]

or else

die $! if $!
[download]

Comment on Re: DBI::mysql fetch() without execute() PROBLEM Select or Download Code

Replies are listed 'Best First'.
Re: Re: DBI::mysql fetch() without execute() PROBLEM by peppiv (Curate) on Jan 22, 2002 at 01:01 UTC
The `die $dbh->errstr if $dbh->errstr;` gives me the same problem (fetch() without execute ()). The `die $! if $!` returns nothing.	[reply] [d/l] [select]
Re^3: DBI::mysql fetch() without execute() PROBLEM by Anonymous Monk on Jan 21, 2021 at 22:03 UTC
I had a similar problem. Looks like that when a script runs fetchrow_array and there is no more lines to be returned, DBD kill the cursor and , so, any try to access methods or attributes of the statement handle ($sth) will raise the error "fetch() without execute()". I solved my problem with a conditional : `$sth->execute() or die "Error executing [$sqlcmd] : " . $dbh->errstr; $end_fetch = 0; do { if (! $end_fetch) { ($key_col, $col1, $col2, $col3) = $sth->fetchrow_array; if (! defined $key_col) { $end_fetch = 1; } } ... } while ($some_condition);` [download]	[reply] [d/l]