想读取符合某一条件(即newsid="& newsid &")的数据表Review中最后一条记录 用"select top 1 * from Review where newsid="& newsid &"order by reviewid desc" 为什么不行?
"select top 1 * from Review where newsid="& newsid &"order by reviewid desc" 改成"select top 1 * from Review where newsid='" & newsid & "' order by reviewid desc" 试试
根据newsid的类型不同,写法也不同