RE: Syntax error in my Update staement

2001-01-23 Thread The Tilghman
uary 23, 2001 13:24 > To: msql list > Subject: Syntax error in my Update staement > > > 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{

Syntax error in my Update staement

2001-01-23 Thread Don
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 = ? AN