Microsoft VBScript 编译器错误 错误 '800a0401'
语句未结束
/upload2.asp,行 35
Recordset2_cmd.CommandText = "SELECT * FROM 鸿城幼稚园 WHERE (([托费到期日期]>=Date()) AND ((鸿城幼稚园.托费到期日期)<DateAdd("d",7,Date()))) ORDER BY [学号] ASC"
---------------------------------------------------------------------------------^
还有一个疑问我修改代码调试后^符号总是跟在Date下面是什么意思?
"SELECT * FROM 鸿城幼稚园 WHERE (([托费到期日期]>=Date()) AND ((鸿城幼稚园.托费到期日期)<DateAdd("d",7,Date()))) ORDER BY [学号] ASC" 引号里面包含引号了,"d",改成""d"",多加一个引号,转义一下
VB不支持换行,要换行,需要加上一个下划线,并且不能在字符串内换行。比如
sql = "SELECT * " & _
"FROM x"
谢谢你们的热心回答 是“”的原因