UC知道请各位高手帮我看一下这段ASP代码哪里有问题
来源：百度知道 编辑：UC知道 时间：2024/05/21 09:16:30
<%@ Language=VBScript %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<P> </P>
<%
dim mysql
dim NewUserID,NewUserPWD,IPAdd,connstr,shujvku,mysql1,birthday,aihao,zhuzhi
NewUserID=Request.Form("uid")
NewUserPWD=Request.Form("pwd1")
IPAdd=Request.ServerVariables("Remote_Host")
birthday=Request.Form("birthday")
aihao=Request.Form("aihao")
zhuzhi=Request.Form("zhuzhi")
shujvku="/ceshi/shujv/shangp2.mdb"
Connstr="DBQ="+server.mappath(shujvku)+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;ImplicitCommitSync=Yes;MaxBufferSize=512;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<P> </P>
<%
dim mysql
dim NewUserID,NewUserPWD,IPAdd,connstr,shujvku,mysql1,birthday,aihao,zhuzhi
NewUserID=Request.Form("uid")
NewUserPWD=Request.Form("pwd1")
IPAdd=Request.ServerVariables("Remote_Host")
birthday=Request.Form("birthday")
aihao=Request.Form("aihao")
zhuzhi=Request.Form("zhuzhi")
shujvku="/ceshi/shujv/shangp2.mdb"
Connstr="DBQ="+server.mappath(shujvku)+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;ImplicitCommitSync=Yes;MaxBufferSize=512;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;
貌似数据库连接有问题啊
connstr="DBQ="+server.mappath("ceshi/shujv/shangp2.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
set conn=server.createobject("ADODB.CONNECTION")
这样就可以连接上数据库了，语句太多容易出错。
还有
mysql1="insert yonghu (uid,pwd,ip,shengri,aihao,zhuzhi) values ('"&NewUserID&"','"&NewUserPWD&"','"&IPAdd&"','"&birthday&"','"&aihao&"','"&zhuzhi&"')"
myrecord.execute(mysql1)
可能是这里出错了，最好不要这样添加记录
这样最好
set rs=server.createobject("adodb.recordset")
sql="select * from database"
rs.open sql,conn,3,3
rs.addnew
rs("uid")=NewUserID
rs("xxx")=xxxx
rs.update
这样方便也不容易出错。
还有，加我qq:23965905，一起讨论asp吧
----------------------------------------------------
回答：
？怎么添加7个记录就无法显示了？
这样的问题真的很少见