对象不支持open方法:
来源:百度知道 编辑:UC知道 时间:2024/06/07 15:15:40
我的代码:
dim conn,rq,opq
set conn = Server.CreateObject("adodb.connection")
conn.connectionstring= "DRIVER={Microsoft Access Driver(*.mdb)};"&"dbq="& server.mappath("webziyuan.mdb")
rq = Server.CreateObject("adodb.recordset")
rq.open "select * from title"
do while (not rq.eof)
response.write("<tr>")
response.write("<td align=left>"& opq("url") &" </td>")
response.write("<td align=left>"& opq("title") &" </td>")
response.write("<td align=left>"& opq("beizu") &" </td>")
response.write("<td align=left>"& opq("date") &" </td>")
response.write("</tr>")
loop
反回的错误提示
dim conn,rq,opq
set conn = Server.CreateObject("adodb.connection")
conn.connectionstring= "DRIVER={Microsoft Access Driver(*.mdb)};"&"dbq="& server.mappath("webziyuan.mdb")
rq = Server.CreateObject("adodb.recordset")
rq.open "select * from title"
do while (not rq.eof)
response.write("<tr>")
response.write("<td align=left>"& opq("url") &" </td>")
response.write("<td align=left>"& opq("title") &" </td>")
response.write("<td align=left>"& opq("beizu") &" </td>")
response.write("<td align=left>"& opq("date") &" </td>")
response.write("</tr>")
loop
反回的错误提示
ASP脚本前后要加<% %>你加了没有?
rq.open "select * from title"
改成
rq.open "select * from title",conn,2,3
还想问下opq是什么?
rq = Server.CreateObject("adodb.recordset")
改为 set rq = Server.CreateObject("adodb.recordset")