%
Set UploadForm = Server.CreateObject("SiteGalaxyUpload.Form")
if UploadForm("name") <> "" then
%>
<%
set userinfo = server.createobject("ADODB.Connection")
userinfo.open session("dsn")
set reqfield=userinfo.execute("select max(ÀϷùøÈ£),count(*) from " & session("linktable"))
if reqfield.fields(1) < 1 then
seqn = 1
else
seqn = reqfield.fields(0) + 1
end if
wdate = Year(now) & "-" & Month(now) & "-" & Day(now)
re_level = 0
'-----------Á¦¸ñ, ³»¿ë Á¤¸® --------------
subject = Replace(UploadForm("subject"), "'", "''")
textdata = Replace(textdata, "'", "''")
textdata = Replace(textdata, chr(32), " ")
textdata = Replace(textdata, chr(13), "
")
'-----------Á¦¸ñ, ³»¿ë Á¤¸® --------------
%>
<%
userinfo.execute("insert into " & session("linktable") & " values (" & seqn & ",'" & _
wdate & "','" & _
UploadForm("name") & "','" & _
UploadForm("pwd") & "','" & _
UploadForm("email") & "','" & _
"'," & _
re_level & ",'" & _
subject & "','" & _
textdata & "','" & _
filename & "',0)")
userinfo.close
set userinfo=nothing
response.redirect "boardlist.asp"
end if
%>