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
fl******@umn.edu
www.cancer.umn.edu

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw