form表单提交的问题(小弟今天刚学asp)
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" >
<SCRIPT language=javascript1.2>
function showsubmenu(sid)
{
whichEl = eval("submenu" + sid);
if (whichEl.style.display == "none")
{
eval("submenu" + sid + ".style.display=\"\";");
}
else
{
eval("submenu" + sid + ".style.display=\"none\";");
}
}
</SCRIPT>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="5" align="center">
<%
if Trim(Request.Form("submit"))="订购" then
dim merchandisename,numbe,title,danwei,tel,fax,email,text,address,post
merchandisename=nohtml(Trim(Request.Form("merchandisename")))
numbe=nohtml(Trim(Request.Form("numbe")))
title=nohtml(Trim(Request.Form("title")))
danwei=nohtml(Trim(Request.Form("danwei")))
tel=nohtml(Trim(Request.Form("tel")))
fax=nohtml(Trim(Request.Form("fax")))
email=nohtml(Trim(Request.Form("email")))
text=nohtml(Trim(Request.Form("text")))
address=nohtml(Trim(Request.Form("address")))
post=nohtml(Trim(Request.Form("post")))
set rs=server.CreateObject("ADODB.Recordset")
sql="select * from OnLineOrder"
rs.open sql,conn,1,3
rs.addnew
rs("merchandisename")=merchandisename
rs("numbe")=numbe
rs("title")=title
rs("danwei")=danwei
rs("tel")=tel
rs("fax")=fax
rs("email")=email
rs("text")=text
rs("address")=address
rs("post")=post
rs.update
rs.requery
rs.close
set rs=nothing
Response.Write "<script>alert('感谢您订购我们的产品!');location.href='OnlineMessage.asp'</script>"
end if
%>
<table width="100%" border="0" cellspacing="0" cellpadding="0" style="border:1px solid #CCCCCC ">
</table>
</td>
</tr>
<tr>
<td height="" align="center">
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#E8E8E8">
<form name="form4" method="post" action="Data/OnLineOrder.asp" onSubmit="return check_dindan();">
<script language="JavaScript" type="text/JavaScript">
// 验证用户名和留言
function check_dindan(){
var notnull;
notnull=true;
if (document.form4.merchandisename.value==""){
alert("请填写您要订购的产品名称!");
document.form4.merchandisename.focus();
notnull=false;
}
else
if (document.form4.numbe.value==""){
alert("请填写您要订购的商品数量!");
document.form4.numbe.focus();
notnull=false;
}
else
if (document.form4.title.value==""){
alert("请填写您的姓名!");
document.form4.title.focus();
notnull=false;
}
else
if (document.form4.tel.value==""){
alert("请留下您的电话号码!");
document.form4.tel.focus();
notnull=false;
}
else
if (document.form4.address.value==""){
alert("请填写您的详细通信地址!");
document.form4.address.focus();
notnull=false;
}
return notnull;
}
</script>
<tr>
<td align="center">
<table width="100%" border="0" cellpadding="4" cellspacing="0">
<tr>
<td> <font style="font-size:14px;">以下是您要订购
的商品信息,请填写完善您的订购信息!以便我们与您取得联系!</font></td>
</tr>
</table>
<table width="100%" border="0" cellpadding="1" cellspacing="1"
bgcolor="#CCCCCC">
<tr bgcolor="#FFFFFF">
<td width="24%" height="20" align="center" class="border">商品名称
:</td>
<td height="20" align="left" class="border"><input
name="merchandisename" type="text" id="numbe" size="10" class="input1">
<font color="#FF0000">*</font></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="20" align="center" class="border">订购数量:</td>
<td height="20" align="left" class="border"><input name="numbe"
type="text" id="numbe" size="10" class="input1">
<font color="#FF0000">*</font></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="20" align="center" class="border">您的单位:</td>
<td height="20" align="left" class="border"><input name="danwei"
type="text" id="danwei" size="25" class="input1"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="20" align="center" class="border">您的姓名:</td>
<td height="20" align="left" class="border"><input name="title"
type="text" id="title" size="15" maxlength="15" class="input1">
<font color="#FF0000">*</font></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="20" align="center" class="border">您的电话:</td>
<td height="20" align="left" class="border"><input name="tel"
type="text" id="tel" size="15" class="input1">
<font color="#FF0000">*</font></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="20" align="center" class="border">传
真:</td>
<td height="20" align="left" class="border"><input name="fax"
type="text" id="fax" size="15" class="input1"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="20" align="center" class="border">邮政编码:</td>
<td height="20" align="left" class="border"><input name="post"
type="text" id="post" size="10" class="input1"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="20" align="center" class="border">电子邮件:</td>
<td height="20" align="left" class="border"><input name="email"
type="text" id="email" size="20" class="input1"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="20" align="center" class="border">详细地址:</td>
<td height="20" align="left" class="border"><input name="address"
type="text" id="address" size="35" class="input1">
<font color="#FF0000">*</font></td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="center" class="border">说 明:</td>
<td height="80" align="left" class="border"><textarea name="text"
cols="45" rows="5" id="text" class="input1"></textarea></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30" align="center" valign="bottom"><input name="Submit6"
type="submit" class="submit" value="订购"> <input name="Submit22" type="reset"
class="submit" onClick="javascript:self.close();openr=null;" value=" 取消 "></td></tr>
</table>
<table width="400" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="26"></td>
</tr>
</table>
</td>
</tr>
</form>
</table>
</td>
</tr>
</table>
提交数据不到数据库,请帮忙看看