以下是此页面代码,请高手帮我看下.我该怎么写把UBB里面的值存入shangpingnr 表里,多谢了,小弟在线等
<!--#include file="../inc/conn.asp"-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" " http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns=" http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>添加商品</title>
<script language = "JavaScript">
function CheckForm()
{
if (editor.EditMode.checked==true)
document.myform.Content.value=editor.HtmlEdit.document.body.innerText;
else
document.myform.Content.value=editor.HtmlEdit.document.body.innerHTML;
return true;
}
</script>
</head>
<body>
<%
if request.Form("Submit")="提交" then
shangpingname=request.Form("shangpingname")
shangpingjg=request.form("shangpingjg")
shangpingimg=request.form("shangpingimg")
shangpingcz=request.form("shangpingcz")
shangpingys=request.form("shangpingys")
shangpingcc=request.form("shangpingcc")
shangpingxl=request.form("shangpingxl")
shangpingnr=request.form("content")
sql="insert into shangping (shangpingname,shangpingjg,shangpingimg,shangpingcz,shangpingys,shangpingcc,shangpingxl,shangpingnr) values ('"&shangpingname&"','"&shangpingjg&"','"&shangpingimg&"','"&shangpingcz&"','"&shangpingys&"','"&shangpingcc&"','"&shangpingxl&"','"&shangpingnr&"')"
conn.execute(sql)
%>
<div align="center"><a ><font color="#FF0000">添加成功</font></a><br /><a href="tjsp.asp">返回</a></div>
<%
response.End()
end if
%>
<form id="frm" name="myform" method="post"><table width="600" border="1" align="center" cellpadding="0" cellspacing="1" bordercolor="#CCCCCC">
<tr>
<td colspan="2" align="center"><strong>添加商品</strong></td>
</tr>
<tr>
<td width="72">商品名称:</td>
<td width="540"><label>
<input name="shangpingname" type="text" id="shangpingname" size="15" maxlength="20" />
</label></td>
</tr>
<tr>
<td>商品价格:</td>
<td><label>
<input name="shangpingjg" type="text" id="shangpingjg" size="10" maxlength="5" />
元</label></td>
</tr>
<tr>
<td>商品系列:</td>
<td><label>
<input name="shangpingxl" type="text" id="shangpingxl" size="10" maxlength="6" />
</label></td>
</tr>
<tr>
<td>图片上传:</td>
<td><label>
<input name="shangpingimg" type="text" id="shangpingimg" size="20" maxlength="20" />
</label></td>
</tr>
<tr>
<td>商品材质:</td>
<td><label>
<input name="shangpingcz" type="text" id="shangpingcz" size="8" maxlength="10" />
</label></td>
</tr>
<tr>
<td>商品颜色:</td>
<td><label>
<input name="shangpingys" type="text" id="shangpingys" size="5" maxlength="6" />
色
</label></td>
</tr>
<tr>
<td>商品尺寸:</td>
<td><label>
<input name="shangpingcc" type="text" id="shangpingcc" size="15" maxlength="15" />
CM</label></td>
</tr>
<tr>
<td colspan="2" align="center"><strong>商品详细</strong></td>
</tr>
<tr>
<td colspan="2"><textarea name="Content" ></textarea>
<iframe ID="editor" src="UBB/editor.asp" frameborder=1 scrolling=no width="620" height="405"></iframe></td>
</tr>
<tr>
<td colspan="2" align="center"><label>
<input type="submit" name="Submit" value="提交" />
<input type="reset" name="Submit2" value="重置" />
</label></td>
</tr>
</table>
</form>
</body>
</html>