水命与水命结婚好吗:asp网页注册求助
我做一个注册页面
当做到检测用户名是否已经使用的时候出现了一个错误
下面是代码:
set rst=server.createobject("adodb.recordest")
rst.open "select * from info where u_id='" & request.form("u_id") & "'",conn,1,1
if rst.recordcount>0 then
response.write "用户名:"& request.form("u_id") & "已经被占用!请返回上一页!"
response.end
else
set rst1=conn.execute("insert into info (u_id) values ('" & request.form("u_id") & "')")
end if
以下是错误:
Microsoft OLE DB Provider for ODBC Drivers 错误 '800401f3'
[Microsoft][ODBC Microsoft Access Driver]常见错误 不能打开注册表关键字 'Temporary (volatile) Jet DSN for process 0x1d9c Thread 0xc08 DBC 0x173b024 Jet'。
/wxhmqe/index.asp,行 137
哪位大哥能帮忙解决一下,谢谢~~!
rst.open "select * from info where u_id='" & request.form("u_id") & "'",conn,1,1
后面的1,1是对数据库的操作只读属性!
改成1,3吧,因为你后面的set rst1=conn.execute("insert into info (u_id) values ('" & request.form("u_id") & "')") 是向数据库里面插入记录!
直接
conn.execute("insert into info (u_id) values ('" & request.form("u_id") & "')")
就可以了
不用再建立一个对象
set rst=server.createobject("adodb.recordest")
rst.open "select * from info where u_id='" & request.form("u_id") & "'",conn,1,1
if rst.recordcount>0 then
response.write "用户名:"& request.form("u_id") & "已经被占用!请返回上一页!"
response.end
else
conn.execute("insert into info (u_id) values ('" & request.form("u_id") & "')")
end if
set rst1=conn.execute("insert into info (u_id) values ('" & request.form("u_id") & "')") 这句有错误
改成这样试试:
set rst1=server.createobject("adodb.recordest")
rst1.open "select * from info where u_id='" & request.form("u_id") & "'",conn,1,1
set rst1=conn.execute("insert into info (u_id) values ('" & request.form("u_id") & "')")