主页

如何将&formPath&File.FileName&这种字段读入数据库？

cwdn 2002-07-20 09:21:10

麻烦死了，谁能帮帮我？


<html>
<head>
<title>文件上传</title>
</head>
<body>
 文件上传!<hr size=1 noshadow width=300 align=left> 

<%
dim upload,file,formName,formPath,iCount
set upload=new upload_5xSoft ''建立上传对象

response.write upload.Version&" " ''显示上传类的版本

if upload.form("filepath")="" then ''得到上传目录
HtmEnd "请输入要上传至的目录!"
set upload=nothing
response.end
else
formPath=upload.form("filepath")
''在目录后加(/)
if right(formPath,1)<>"/" then formPath=formPath&"/"
end if
dim rs1
dim rs

Set rs1=Server.CreateObject("ADODB.command")
set rs=server.createobject("ADODB.Recordset")
rs1.CommandText = "SELECT * FROM sp where 日期=date() "
rs1.CommandType = 1
Set rs1.ActiveConnection = conn
rs.Open rs1, , 1, 3
rs.addnew

iCount=0
for each formName in upload.file ''列出所有上传了的文件
set file=upload.file(formName) ''生成一个文件对象
if file.FileSize>0 then ''如果 FileSize > 0 说明有文件数据
file.SaveAs Server.mappath(formPath&file.FileName) ''保存文件
rs("dt")="&formPath&File.FileName&"
response.write file.FilePath&file.FileName&" ("&file.FileSize&") => "&formPath&File.FileName&" 成功! "
iCount=iCount+1
end if
set file=nothing
next
set upload=nothing ''删除此对象
Htmend iCount&" 个文件上传结束!"

sub HtmEnd(Msg)
set upload=nothing
response.write " "&Msg&" [<a href=""javascript:history.back();"">返回</a>]</body></html>"
response.end
end sub
%>

...全文