📄 new.asp
字号:
<%
' FP_ASP FrontPage 组件自动产生 ASP 。请勿编辑。On Error Resume Next
Session("FP_OldCodePage") = Session.CodePage
Session("FP_OldLCID") = Session.LCID
Session.CodePage = 936
Err.Clear
strErrorUrl = ""
If Request.ServerVariables("REQUEST_METHOD") = "POST" Then
If Request.Form("VTI-GROUP") = "0" Then
Err.Clear
Set fp_conn = Server.CreateObject("ADODB.Connection")
FP_DumpError strErrorUrl, "无法创建连接"
Set fp_rs = Server.CreateObject("ADODB.Recordset")
FP_DumpError strErrorUrl, "无法创建记录集"
fp_conn.Open Application("database_ConnectionString")
FP_DumpError strErrorUrl, "无法打开数据库"
fp_rs.Open "Results", fp_conn, 1, 3, 2 ' adOpenKeySet, adLockOptimistic, adCmdTable
FP_DumpError strErrorUrl, "无法打开记录集"
fp_rs.AddNew
FP_DumpError strErrorUrl, "无法将新记录集添加到数据库"
Dim arFormFields0(3)
Dim arFormDBFields0(3)
Dim arFormValues0(3)
arFormFields0(0) = "Field2"
arFormDBFields0(0) = "名称"
arFormValues0(0) = Request("Field2")
arFormFields0(1) = "Field3"
arFormDBFields0(1) = "地址"
arFormValues0(1) = Request("Field3")
arFormFields0(2) = "Field4"
arFormDBFields0(2) = "选项"
arFormValues0(2) = Request("Field4")
FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0
fp_rs.Update
FP_DumpError strErrorUrl, "无法更新数据库"
fp_rs.Close
fp_conn.Close
Session("FP_SavedFields")=arFormFields0
Session("FP_SavedValues")=arFormValues0
Session.CodePage = Session("FP_OldCodePage")
Session.LCID = Session("FP_OldLCID")
Response.Redirect "confirm.asp"
End If
End If
Session.CodePage = Session("FP_OldCodePage")
Session.LCID = Session("FP_OldLCID")
%>
<!--#include File='login.asa'--><% If Session(SiteID) <> true Then Response.Redirect("Login.asp?requester=submission_form.asp") End If%>
<% Response.Buffer = True %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>结果 -- 新建</title>
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
</head>
<body bgcolor="#FFFFFF">
<table width="100%" align=left>
<tr>
<td width="50%">
<b><font size=+3 color="#000080"> 提交表单 </font></b>
</td>
<td width="50%" align=right>
<table>
<tr>
<td>
</td>
</tr>
</table>
</td>
</tr>
</table>
<p>
<br clear="all">
<hr>
<p>
<!--webbot BOT="GeneratedScript" PREVIEW=" " startspan --><script Language="JavaScript" Type="text/javascript"><!--
function FrontPage_Form1_Validator(theForm)
{
if (theForm.Field2.value.length > 255)
{
alert("在 Field2 域中，请最多输入 255 个字符。");
theForm.Field2.focus();
return (false);
}
return (true);
}
//--></script><!--webbot BOT="GeneratedScript" endspan --><form METHOD="POST" action="new.asp" onsubmit="return FrontPage_Form1_Validator(this)" language="JavaScript" name="FrontPage_Form1" webbot-action="--WEBBOT-SELF--">
<!--webbot bot="SaveDatabase" SuggestedExt="asp" S-DataConnection="database" S-RecordSource="Results" U-Confirmation-Url="confirm.asp" S-Form-Fields="Field2 Field3 Field4" S-Form-DBFields="名称 地址 选项 " B-UseDBFieldsForConfirmation="True" U-ASP-Include-Url="../../../_fpclass/fpdbform.inc" startspan --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--#include file="../../../_fpclass/fpdbform.inc"--><!--webbot bot="SaveDatabase" i-checksum="52631" endspan -->
<p><b>名称</b><br> <!--webbot bot="Validation" s-display-name="Field2" s-data-type="String" b-value-required="False" i-maximum-length="255" --><input type="TEXT" name="Field2" size="64" value="" maxlength="255"><br></p><p><b>地址</b><br> <!--webbot bot="Validation" s-display-name="Field3" s-data-type="String" b-value-required="False" i-maximum-length="0" --><textarea rows="10" name="Field3" cols="64"></textarea><br></p><p><b>选项</b><br><p><input type="radio" name="Field4" value=1 >选项 1</p><p><input type="radio" name="Field4" value=2 >选项 2</p><p><input type="radio" name="Field4" value=3 >选项 3</p><br></p>
<p><input type="submit" value="确定"><input type="reset" value="重置"></p>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -