我在编程时用到语句
"SELECT count(*) FROM votecount WHERE optionID='+(Rs5.fieclds.Item("OptionID").Value")+'"
在测试时出现数据类型不匹配(明明Rs5.fieclds.Item("OptionID").Value的数据类型是数字)还是说数据类型不匹配
在运行时出现
Microsoft VBScript 编译器错误 (0x800A0401)
语句未结束
/tp1/votestatistic.asp, line 93, column 83
Rs7.Source = "SELECT count(*) FROM votecount WHERE optionID='+(Rs5.fieclds.Item("OptionID").Value")+'"
----------------------------------------------------------------------------------^
请教数字类型的变量在语句中应该如何写。我这语句的错误在哪里？谢谢！

无论我改写成下面那一种都出现编译器错误提示未结束的字符串常量
Rs7.Source = "SELECT count(*) FROM votecount WHERE optionID="+(Rs5.fields.Item("OptionID").Value)"
Microsoft VBScript 编译器错误 (0x800A0409)
未结束的字符串常量
/tp1/votestatistic.asp, line 93, column 101
Rs7.Source = "SELECT count(*) FROM votecount WHERE optionID="+(Rs5.fields.Item("OptionID").Value")
如果我写成
Rs7.Source = "SELECT count(*) FROM votecount WHERE optionID=1就可以通过,但我要的是变量,问题是数字型变量在表达式中应该如何写?
----------------------------------------------------------------------------------------------------^