in reply to $dbh->errstr;

Am,

prepare just parses the sql statement (readies it for execution). You still need to execute the sql.

$sth = $dbh->prepare( "Your sql statement" ) or die "yadda"; $sth->execute();

Also, you may want to look at the latest tutorial from Tim Bunce (DBI author) on how to write DBI code more idiomatically (using RaisError vice checking errstr, using prepare -vs- prepare_cached, using placeholders, etc).

-derby

Replies are listed 'Best First'.
Re: Re: $dbh->errstr;
by Anonymous Monk on Jul 24, 2002 at 13:34 UTC
    no I just gor prepare mixd up with do, im an ediot