UC知道asp加入access的问题
来源：百度知道 编辑：UC知道 时间：2024/05/22 20:25:27
我想做个动态网页，然后我想用access数据库，我上网找了下要加入access需要加代码
如下：Set Conn = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("datum\users.mdb")
StrConn="Driver={Microsoft Access Driver (*.mdb)};DBQ="&DBPath
Conn.Open StrConn
sql="Select PASSWORD0,NAME0,RANK0 From users_detail Where NAME0='"&TRIM(NAME)&"'"
Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.Open sql,Conn,1,3
sql="insert into users_detail(NAME0,PASSWORD0,WORKTEL0,MOBILETEL0,EMAIL0,RANK0) values('"&username&"','"&password&"','"&userworktel&"','"&usermobiletel&"','"&useremail&"','用户级')"
这段代码怎么加入DW里面？加在哪里？？？
我是菜鸟，请高手指教
如下：Set Conn = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("datum\users.mdb")
StrConn="Driver={Microsoft Access Driver (*.mdb)};DBQ="&DBPath
Conn.Open StrConn
sql="Select PASSWORD0,NAME0,RANK0 From users_detail Where NAME0='"&TRIM(NAME)&"'"
Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.Open sql,Conn,1,3
sql="insert into users_detail(NAME0,PASSWORD0,WORKTEL0,MOBILETEL0,EMAIL0,RANK0) values('"&username&"','"&password&"','"&userworktel&"','"&usermobiletel&"','"&useremail&"','用户级')"
这段代码怎么加入DW里面？加在哪里？？？
我是菜鸟，请高手指教
建立conn.asp,内容如下：
<%
Set Conn = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("datum\users.mdb")
StrConn="Driver={Microsoft Access Driver (*.mdb)};DBQ="&DBPath
Conn.Open StrConn
%>
下面的代码需要调用数据库的话直接
<!--#include file="conn.asp">就好了嘛
<%
Set Conn = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("datum\users.mdb")
StrConn="Driver={Microsoft Access Driver (*.mdb)};DBQ="&DBPath
Conn.Open StrConn
sql="Select PASSWORD0,NAME0,RANK0 From users_detail Where NAME0='"&TRIM(NAME)&"'"
Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.Open sql,Conn,1,3
sql="insert into users_detail(NAME0,PASSWORD0,WORKTEL0,MOBILETEL0,EMAIL0,RANK0) values('"&username&"','"&password&"','"&userworkte