| 编程中国 | 业界新闻 | 技术文章 | 视频教程 | 下载频道 | 程序源码 | 个人空间 | 编程论坛
全能ASP/PHP/ASP.NET主机,支持月付专业 MSSQL 数据库空间,支持月付专业 MySQL 数据库空间,支持月付学习型 ASP/PHP/ASP.NET 主机 30元/年
高端软件开发 = 年薪十万不是梦赛孚耐:软件保护加密专家身份认证令牌USB KEY 
共有 189 人关注过本帖
标题:为什么我用如下代码实现数据插入数据库确提示网页无法实现?
收藏  订阅  推荐  打印 
xwhaohuai
Rank: 1
等级:新手上路
帖子:30
积分:412
注册:2007-9-29
为什么我用如下代码实现数据插入数据库确提示网页无法实现?

<!--#include file="inc/conn.asp"-->
<%
name=replace(trim(request.form("name")),"'","")
sex=replace(trim(request.form("sex")),"'","")
years=replace(trim(request.form("year")),"'","")
months=replace(trim(request.form("month")),"'","")
mobile=replace(trim(request.form("mobile")),"'","")
where=replace(trim(request.form("zhuanye")),"'","")
glass=replace(trim(request.form("glass")),"'","")
zhuanye=replace(trim(request.form("zhuanye")),"'","")
number=replace(trim(request.form("number")),"'","")
phone=replace(trim(request.form("phone")),"'","")

type1=replace(trim(request.form("type1")),"'","")
type2=replace(trim(request.form("type2")),"'","")
type3=replace(trim(request.form("type3")),"'","")
type4=replace(trim(request.form("type4")),"'","")
type5=replace(trim(request.form("type5")),"'","")
type6=replace(trim(request.form("type6")),"'","")
trun=replace(trim(request.form("trun")),"'","")


if name="" then
response.write "<SCRIPT language=JavaScript>alert('姓名不能为空 或 输入字符非法!');"
response.write "this.location.href='vbscript:history.back()';</SCRIPT>"
response.end
end if
if number="" then
response.write "<SCRIPT language=JavaScript>alert('学号不能为空 或 输入字符非法!');"
response.write "this.location.href='vbscript:history.back()';</SCRIPT>"
response.end
end if
if glass="" then
response.write "<SCRIPT language=JavaScript>alert('年级不能为空 或 输入字符非法!');"
response.write "this.location.href='vbscript:history.back()';</SCRIPT>"
response.end
end if
if zhuanye="" then
response.write "<SCRIPT language=JavaScript>alert('专业不能为空 或 输入字符非法!');"
response.write "this.location.href='vbscript:history.back()';</SCRIPT>"
response.end
end if
if mobile="" then
response.write "<SCRIPT language=JavaScript>alert('身份证号不能为空 或 输入字符非法!');"
response.write "this.location.href='vbscript:history.back()';</SCRIPT>"
response.end
end if

if type1="" and type2="" and type3="" and type4="" and type5="" and type6=""then
response.write "<SCRIPT language=JavaScript>alert('必须选择一门课程!');"
response.write "this.location.href='vbscript:history.back()';</SCRIPT>"
response.end
end if
if trun=""then
response.write "<SCRIPT language=JavaScript>alert('必须选择轮数!');"
response.write "this.location.href='vbscript:history.back()';</SCRIPT>"
response.end
end if
%>
<%


set rs=server.createobject("adodb.recordset")
sqltext="select * from orderlist"
rs.open sqltext,cn,3,3

rs.addnew
rs("name")=request.form("name")
rs("number")=request.form("number")
rs("zhuanye")=request.form("zhuanye")
rs("glass")=request.form("glass")
rs("mobile")=request.form("mobile")
rs("phone")=request.form("phone")
rs("where")=request.form("where")
rs("year")=request.form("year")
rs("month")=request.form("month")
rs("sex")=request.form("sex")

rs("type1")=request.form("type1")
rs("type2")=request.form("type2")
rs("type3")=request.form("type3")
rs("type4")=request.form("type4")
rs("type5")=request.form("type5")
rs("type6")=request.form("type6")
rs("trun")=request.form("trun")

rs.update
session("name") = request.form("name")
session("number") = request.form("number")
session("glass") = request.form("glass")
session("mobile") = request.form("mobile")
session("zhuanye") = request.form("zhuanye")
session("year") = request.form("year")
session("month") = request.form("month")
session("sex") = request.form("sex")
session("phone") = request.form("phone")
session("where") = request.form("where")

response.write "<SCRIPT language=JavaScript>alert('报名成功!');"
response.write "this.location.href='application2.asp';</SCRIPT>"
%>
在自己电脑的IIS上就可以运行但放到网上就无法运行了,求救!!!!

搜索更多相关主题的帖子: form  trim  replace  数据库  
2007-10-9 11:16
xwhaohuai
Rank: 1
等级:新手上路
帖子:30
积分:412
注册:2007-9-29

怎么没人说话啊
2007-10-9 11:35
xwhaohuai
Rank: 1
等级:新手上路
帖子:30
积分:412
注册:2007-9-29

哪位大虾可以帮下我吗?谢谢
2007-10-9 11:36
xwhaohuai
Rank: 1
等级:新手上路
帖子:30
积分:412
注册:2007-9-29

2007-10-9 11:39
xiaoyutou
Rank: 1
等级:新手上路
帖子:23
积分:340
注册:2007-3-29

你查看一下你的conn.asp文件,是不是连接数据库的代码有问题,例如"连接的服务器"是不是正确.

凡事由其自然,遇了处之泰然,得意之时淡然,失意之时坦然,艰辛曲折必然,历尽沧桑悟然。
2007-10-9 17:28
关于我们 | 广告合作 | 编程中国 | 清除Cookies | Archiver | WAP | TOP

编程中国 版权所有,并保留所有权利。鲁ICP备08000592号
Powered by Discuz, Processed in 0.060122 second(s), 9 queries.
Copyright©2004-2008, BCCN.NET, All Rights Reserved