This isn't really a DBI issue, more like a PerlScript/ASP issue, but I thought this might be the best place to pose th equestion.
I am converting several data base modules from Perl CGI to PerlScript and have run into the following problem. When I execute an SQL command to update or delete records from a table, I want to know how many records (if any) were affected. According to the ASP documentation dealing with the Execute method for the connection object, the following should do the trick:
$do_sql = $db->Execute($sql_cmd, $recs_affected);
However, while the statement executes fine (as always), the variable $recs_affected never contains a value. I have tried changing the statement to the following: