Hi,
I'm looking at the docs for the UPDATE syntax right now!
Here is my code (in Perl):
$sqlCmd = $dbh->prepare("UPDATE Ports SET Country = $country,
TransPort = $transPort,
Suspended = $suspended,
Transit = $transit,
Tranship = $tranship,
CargoDisp = $disposition
WHERE PortName = $port");
When I issue an: $sqlCmd->execute() or die "Can't execute statement:
$DBI::errstr";
I get the following error message:
DBD::mysql::st execute failed: Unknown column 'GERMANY' in 'field list'
at myprog.pl line 164. Can't execute statement: Unknown column
'GERMANY' in 'field list' at myprog.pl
line 164.
Ports is my table. "GERMANY" is actually the contents of the scaler
array $country, so why is it giving me an unknown column error?
Thanks,
Don
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php