Microsoft VBScript 编译器错误 错误 '800a0401' 语句未结束

Question

Microsoft VBScript 编译器错误 错误 '800a0401'

语句未结束

/upload2.asp，行 35
Recordset2_cmd.CommandText = "SELECT * FROM 鸿城幼稚园 WHERE (([托费到期日期]>=Date()) AND ((鸿城幼稚园.托费到期日期)<DateAdd("d",7,Date()))) ORDER BY [学号] ASC"
---------------------------------------------------------------------------------^
还有一个疑问我修改代码调试后^符号总是跟在Date下面是什么意思？

Answer 1

  "SELECT * FROM 鸿城幼稚园 WHERE (([托费到期日期]>=Date()) AND ((鸿城幼稚园.托费到期日期)<DateAdd("d",7,Date()))) ORDER BY [学号] ASC"   引号里面包含引号了，"d"，改成""d""，多加一个引号，转义一下