我想从Perl文件在mssql中设置日期。这是我的代码:
my $date = strftime "%Y%m%d", localtime();
my $sql = $dbh->prepare("update BlastDatabaseDim set Databasedate = ? DatabaseVersion = ? where DatabaseName = ?");
$sql->execute($date,$DatabaseVersion,$db_name);
此代码有什么问题?
我得到了这个错误:
Can't Execute Command 'update BlastDatabaseDim set Databasedate = ? DatabaseVersion = ? where DatabaseName = ?'
Description : Incorrect syntax near 'DatabaseVersion'.
看起来之间缺少一个逗号
Databasedate = ? DatabaseVersion = ?
应该是
Databasedate = ? ,DatabaseVersion = ?