mysql conformation

[tonyjob]

is there a way to get a conformation from mysql after you insert something into it. so that you know if it was or wasnt succesful.

 

[mbaranski]

$mysqlhandle->do("INSERT $mysqldbname.$currentTable SET $insertStmt\n"

print "Error!!!" if $DBI::err ;
As always, I hope that helped!

Disclaimer:
Beware: Studies have shown that research causes cancer in lab rats.

 

[tonyjob]

so this is the part that gets the error?

print "Error!!!" if $DBI::err

 

[MikeLacey]

I thought it was $DBI::errstr you wanted....

Can you use something like this?

$mysqlhandle->do("INSERT $mysqldbname.$currentTable SET $insertStmt\n&quot or die "INSERT statement problem\n$DBI::errstr\n";
Mike
michael.j.lacey@ntlworld.com
Email welcome if you're in a hurry or something -- but post in tek-tips as well please, and I will post my reply here as well.