Microsoft OLE DB Provider for ODBC Drivers '80040e21' ODBC 驱动程序不支持所需的属性。 \wwwroot\Test.asp, line 6
我的程序是:
<%@LANGUAGE="VBScript" codepage="936"%>
<!--#include file="conn.asp"-->
<%
set rs=server.createobject("adodb.recordset")
sql="select content,time,uname from leave inner join user on leave.uid = user.id"
rs.open sql,conn,1,1
%>
<guestbook>
<%do while not rs.eof%> <record>
<content><%=rs("content")%></content>
<time><%=rs("time")%></time>
</record><%
rs.movenext
loop
%>
</guestbook>
难道rs.open sql,conn,1,1这一句真的有错吗
我如果把sql语句换成select content,time from leave 就没问题了,
这是怎么回事
我的程序是:
<%@LANGUAGE="VBScript" codepage="936"%>
<!--#include file="conn.asp"-->
<%
set rs=server.createobject("adodb.recordset")
sql="select content,time,uname from leave inner join user on leave.uid = user.id"
rs.open sql,conn,1,1
%>
<guestbook>
<%do while not rs.eof%> <record>
<content><%=rs("content")%></content>
<time><%=rs("time")%></time>
</record><%
rs.movenext
loop
%>
</guestbook>
难道rs.open sql,conn,1,1这一句真的有错吗
我如果把sql语句换成select content,time from leave 就没问题了,
这是怎么回事
select leave.content,leave.time,user.uname from leave inner join user on leave.uid = user.id
selet * from leave 看能显示数据吗 ,如果能显示数据 说明驱动等问题没有