[求助]数据添加问题? - ASP技术论坛

问题点数：0 回复次数：0

[求助]数据添加问题?

add.asp页面
　　<table width="450" border="0" cellpadding="0" cellspacing="1" bgcolor="e9e9e9">
<tr bgcolor="#FFFFFF">
<td width="74" height="25"><div align="center">影片名称：</div></td>
<td width="373"><div align="left">
<input name="name" type="text" id="name">
</div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25"><div align="center">主演：</div></td>
<td><div align="left">
<input name="yanyuan" type="text" id="yanyuan">
</div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25"><div align="center">添加时间：</div></td>
<td><div align="left">
<input name="time" type="text" id="time" value="<%=now()%>">
</div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25"><div align="center">产地：</div></td>
<td><div align="left">
<input name="chandi" type="text" id="chandi">
</div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25"><div align="center">图片：</div></td>
<td><div align="left">
<input name="tupian" type="text" id="tupian" value=".jpg">
</div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25"><div align="center">类型：</div></td>
<td><div align="left">
<input name="typeid" type="text" id="typeid">
</div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25"><div align="center">播放地址1：</div></td>
<td><div align="left">
<input name="bofangdizhi" type="text" id="bofangdizhi">
</div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25"><div align="center">播放地址2：</div></td>
<td><div align="left">
<input name="bofangdizhi2" type="text" id="bofangdizhi2">
</div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25"><div align="center">播放地址3:</div></td>
<td><div align="left">
<input name="bofangdizhi3" type="text" id="bofangdizhi3">
</div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25"><div align="center">内容介绍：</div></td>
<td><div align="left">
<textarea name="neirong" cols="50" rows="20" id="neirong"></textarea>
</div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25" colspan="2"><div align="center">
<input type="submit" name="Submit2" value="提交">
　
<input type="submit" name="Submit3" value="重置">
</div></td>
</tr>
</table>

add1.asp

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>

<%if request.Form("name")<>"" and request.Form("yanyuan")<>"" and request.Form("typeid")<>"" and request.Form("neirong")<>"" then
name=request.form("name")
yanyuan=request.form("yanyuan")
typeid=request.form("typeid")
bofangdizhi=request.form("bofangdizhi")
bofangdizhi2=request.form("bofangdizhi2")
bofangdizhi3=request.form("bofangdizhi3")
neirong=request.form("neirong")
tupian=request.form("tupian")
sql="insert into film(name,yanyuan,typeid,bofangdizhi,bofangdizhi2,bofangdizhi3,neirong,tupian)values('"&name&"','"&yanyuan&"','"&typeid&"','"&bofangdizhi&"','"&bofangdizhi2&"','"&bofangdizhi3&"','"&neirong&"','"&tupian&"')"
conn.execute sql
%>
<%conn.close
set conn=nothing
response.Redirect("index.asp")
%>
<%else%>
<script language=javascript>
alert("所填内容不能为空,必须全填!");
history.go(-1)
</script>
<%end if%>
那儿出现问题了

搜索更多相关主题的帖子: 数据　