Hi all,
The compiler is reporting a syntax error in mySQL statement near the
WHERE clause. Help. Perl code is as such:
$sqlCmd = $dbh->prepare (q{
UPDATE Sailings
SET SailPort = ?,
SailDate = ?,
Deleted = ?,
WHERE Vessel = ? AND Voyage = ?
}) or die "Can't update Sailings record: $DBI::errstr";
$sqlCmd->execute($sailPort, $sailDate, $deleted, $vessel, $voyage)
or die "Can't execute update statement into Sailings:
$DBI::errstr";
---------------------------------------------------------------------
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
