Question

语法错误 (操作符丢失) 在查询表达式 'vt_id=' 中。

sub fillVote()
viewstate("voteID")=executeSql("select top 1 vt_id from votetopic order by vt_id desc","admin.mdb")
voteTitle.text=executeSql("select vt_name from votetopic where vt_id=" & viewstate("voteID"),"admin.mdb")

dim sql as string="select * from voteitem where vt_id=" & viewstate("voteID")
dim conn as new oledbconnection("provider=microsoft.jet.oledb.4.0; data source="+server.MapPath("data/admin.mdb"))
dim objreader as oledbdatareader
dim objcmd as new oledbcommand(sql,conn)
try
objcmd.connection.open()
objreader=objcmd.executereader()
vote.datasource=objreader
vote.databind()
catch ex as exception
response.Write(ex.message)
finally
objcmd.connection.close()
end try
end sub

Answer 1

viewstate("voteID")
这个获取不到或者包括一些特殊的字符,比如: ' / 等

Answer 2

可能id没传过来。

Answer 3

天书