Microsoft VBScript 编译器错误 (0x800A0408)
无效字符
/lj/dispose_demand.asp, line 41, column 3
sql＝sql&"select * from REQUIRE_BILL where CONVERT(int,MONTH(date))>=time and CONVERT(int,MONTH(date))<=time1"
--^


出错了

不能这样写，time和time1是变量不能直接写进去

晕那怎么写，我下面就是按照你教我的写的哦，难道我又理解错误啦，，写段我看看嘛多谢哈
if APPLY_TIME <>"" then
time=cint(APPLY_TIME)
else
time=0
end if
if APPLY_TIME_end <>"" then
time1=cint(APPLY_TIME_end)
else
time1=0
end if
if time<>0 and time1<>0 then
sql＝sql&"select * from REQUIRE_BILL where CONVERT(int,MONTH(date))>=time and CONVERT(int,MONTH(date))<=time1"
end if

if time<>0 and time1=0 then
sql=sql&"select * from REQUIRE_BILL where CONVERT(int,MONTH(date))>=time"
end if
if time=0 and time1<>0 then
sql=sql&"select * from REQUIRE_BILL where CONVERT(int,MONTH(date))<=time1"
end if

我上面只是写的ＳＱＬ语句
time是变量
sql＝sql&"select * from REQUIRE_BILL where CONVERT(int,MONTH(date))>="&cstr(time)&" and CONVERT(int,MONTH(date))<="&cstr(time)

if APPLY_TIME <>"" then
time=cint(APPLY_TIME)
else
time=0
end if
if APPLY_TIME_end <>"" then
time1=cint(APPLY_TIME_end)
else
time1=0
end if
if time<>0 and time1<>0 then
sql＝sql&"select * from REQUIRE_BILL where CONVERT(int,MONTH(date))>="&cstr(time)&" and CONVERT(int,MONTH(date))<="&cstr(time)&""
end if

Microsoft VBScript 编译器错误 (0x800A0408)
无效字符
/lj/dispose_demand.asp, line 42, column 3
sql＝sql&"select * from REQUIRE_BILL where CONVERT(int,MONTH(date))>="&cstr(time)&" and CONVERT(int,MONTH(date))<="&cstr(time)&""


还是不对

sql=
sql＝

是这里的原因吧，你看看那个等号是什么输入法的？

放任一切，你真的很厉害

万分感谢～～～～～～～～～

呵呵，共同学习！

[此贴子已经被作者于2007-7-10 14:01:31编辑过]