ORA-01461 can bind a LONG value only for insert into a LONG columnCause: An attempt was made to insert a value from a LONG datatype into another datatype. This is not allowed. Action: Do not try to insert LONG datatypes into other types of columns.
调试欢乐多
filename=request("filename")
filepath=request("filepath")
rarname=request("rarname")
rarpath=request("rarpath")
content="" & replace(filename,",",chr(13) & chr(10))
set rs=conn.dbcreatedynaset("select seq_baowenupload.nextval from dual",4)
if not rs.eof then id=rs(0)
rs.close
set rs=conn.dbcreatedynaset("select * from baowenupload where 1=2",0)
rs.addnew
rs("id").value=id
rs("filename").Value = Empty
rs("rarfilename").Value = rarname
rs("filepath").Value = filepath
rs("rarfilepath").Value = rarpath
rs("username").Value = session("username")
rs("savetime").Value = Now
rs("upload_").Value = 0
rs("read_").Value = 0
rs.Update
rs.close
sql="select * from baowenupload where id=" & id
set rs=conn.dbcreatedynaset(sql,0)
if not rs.eof then
rs.edit
set fil=rs("filename").value
fil.write content
rs.update
rs.close
end if
rs.close
if err.number<>0 then
response.write err.description
end if
这是我的代码 很简单的asp的 拜托给看看