高手请看这段怎么过不去呢

[germ007]

set rs0=server.CreateObject("adodb.recordset")
    rs0.open "select * from office_message_board",conn,1,1
set rs=server.CreateObject("adodb.recordset")
    rs.open "select * from office_message_board where '"&trim(rs0("vip"))&"'='"&trim(session("&admin&"))&"' order by [time] desc",conn,1,1

[孟子E章]

你先打印出
"select * from office_message_board where '"&trim(rs0("vip"))&"'='"&trim(session("&admin&"))&"' order by [time] desc"
看是什么，考到查询分析器里去试试是否合法

[germ007]

是不是套用的问题？？？？

[germ007]

ding................

[germ007]

ding..................

[行间]

select * from office_message_board where '"&trim(rs0("vip"))&"'='"&trim(session("&admin&"))&"' order by [time] desc

应该是这个有问题

[月光下的土豆]

select * from office_message_board where "&trim(rs0("vip"))&" = '"&trim(session("&admin&"))&"' order by [time] desc

[Dogfish]

先看看第一个是否有返回数据。

[Dogfish]

set rs0=server.CreateObject("adodb.recordset")
rs0.open "select * from office_message_board",conn,1,1
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from office_message_board where " & trim(rs0("vip")) & "='" & trim(session("&admin&")) & "' order by [time] desc",conn,1,1

[germ007]

不行啊，Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
ODBC 驱动程序不支持所需的属性

[germ007]

在线等,哈哈,刚才放花去了