asp语句未结束问题

来源:百度知道 编辑:UC知道 时间:2024/05/14 05:35:54
这是用DW写的,在写记录集的时候测试是没有问题的,一用IE 测试就出现语句未结束
代码如下:
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_cn_STRING
Recordset1.Source = "SELECT count(*) as num1 FROM student WHERE caiwu="1" AND houqing="1" AND suguang="1" AND xibu="1""
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

如果你确定那个'1' 是字符型的话,这一句应该这样写
Recordset1.Source ="SELECT count(*) as num1 FROM student WHERE caiwu='1' AND houqing='1' AND suguang='1' AND xibu='1'"