主题:关于数据库查寻的问题
<%
Dim connstr,myconn
connstr="provider=microsoft.jet.oledb.4.0;data source=" & server.mappath("../config_conn/root_conn.mdb")
set myconn=server.createobject("ADODB.connection")
myconn.connectionstring=connstr
myconn.open
%>
<%
id=request.querystring("id")
dim myrec,rs
myrec="select * form liuyan_table where id='"& id &"'"
set rs=myconn.execute(myrec)
%>
请大家帮忙看看,这段代码总提示在set rs=myconn.execute(myrec)报错,我检查许久了,也没有发现是哪里出了问题
Dim connstr,myconn
connstr="provider=microsoft.jet.oledb.4.0;data source=" & server.mappath("../config_conn/root_conn.mdb")
set myconn=server.createobject("ADODB.connection")
myconn.connectionstring=connstr
myconn.open
%>
<%
id=request.querystring("id")
dim myrec,rs
myrec="select * form liuyan_table where id='"& id &"'"
set rs=myconn.execute(myrec)
%>
请大家帮忙看看,这段代码总提示在set rs=myconn.execute(myrec)报错,我检查许久了,也没有发现是哪里出了问题