Problem with UPDATE via CGI

[Peter Fleck]

I'm having some trouble updating a mysql database with a perl cgi.

Here's the perl:

$sql = "UPDATE grants SET agency2 = \"$agency2\" WHERE agency2 = \"$key\"";
$rv = do($sql)
      or die "Can't execute $sql: $dbh->errstr\n<br>";
Here's the error returned in the browser:

Can't execute UPDATE grants SET agency2 = "Academic Health Center" 
WHERE agency2 = "AHC": DBI::db=HASH(0x8232154)->errstr <br> at 
/var/www/cgi-bin/test/chag2.cgi line 35, <AG> line 1.

The update command works with no problem when I use it from the 
command line in mysql with same user and password. SELECT and INSERTs 
work via cgi with 'prepare' and 'execute'. I'm wondering if 'do' is 
my problem.
--
Peter Fleck
University of Minnesota Cancer Center
[EMAIL PROTECTED]
www.cancer.umn.edu

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]