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]