Problem with Prepared statement

seshusatya

Hi All,

I have got problem with my prepared statement.

I need to update a value in to DB.

I hardcoded those values and it worked.

But when I am trying to do the same using prepared statement it is not updating the value in database and not even throwing an error.

Pls find the code:-

my $stmt = "update table set level = '?' where record_path like '%18032%'";
my $sth = $dbh->prepare($stmt)
or die "Can not prepare SQL statement: $DBI::errorstr\n";
$sth->execute('hello');
$dbh->disconnect or warn "Disconnection failed: $DBI::errstr\n";


Here the level value should be hello after updating.

Thanks in advance........

thanks,
chkri

Pawan

Hi All, I have got problem with my prepared statement. I need to update a value in to DB. I hardcoded those values and it worked. But when I am trying to do the same using prepared statement it is not updating the value in database and not even throwing an error. Pls find the code:- my $stmt = "update table set level = '?' where record_path like '%18032%'"; my $sth = $dbh->prepare($stmt) or die "Can not prepare SQL statement: $DBI::errorstr\n"; $sth->execute('hello'); $dbh->disconnect or warn "Disconnection failed: $DBI::errstr\n"; Here the level value should be hello after updating. Thanks in advance........ thanks, chkri

Hi,

Try to capture the return value from the execute statement. May be the value paased is getting lost or overwritten somewhere.

Thanks,
Pawan