|
最后一句中sql = "insert into upload(upfile,filename,filetype,filesize,baks) values ('"& uppath &"','"&oFile.FileName&"','"& oFile.FileExt &"',"&oFile.filesize&")" 你要求在表中插入的字段是(upfile,filename,filetype,filesize,baks),共五个字段, 但你只提供了四个字段的值('"& uppath &"','"&oFile.FileName&"','"& oFile.FileExt &"',"&oFile.filesize),最后一个字段baks没有指定值.可以改成如下形式:sql = "insert into upload(upfile,filename,filetype,filesize) values ('"& uppath &"','"&oFile.FileName&"','"& oFile.FileExt &"',"&oFile.filesize&")" 或sql = "insert into upload(upfile,filename,filetype,filesize,baks) values ('"& uppath &"','"&oFile.FileName&"','"& oFile.FileExt &"',"&oFile.filesize&",null)" 提示: 遇到这种问题,可以将SQL输出,再仔细检查.祝你好运! |
