实在没辙了·~帮我看下，生日提醒问题

[91jk]

sql = "select * from kedate where datediff('d',cstr(year(date())) + '-' + cstr(month(Birthday)) + '-' + cstr(day(Birthday)),date())<="&remindDays &" and datediff('d', cstr(year(date())) + '-' + cstr(month(Birthday)) + '-' + cstr(day(Birthday)),date())>=0 order by ID desc"


数据库ACCESS的，birthday字段格式是时间型的。。。但是就是老提示“无效的 null 使用
”，而且打印SQL也打印不出来，请帮我指点指点，谢谢了·~~

[sunrainnet]

Birthday变量里面有没有值？你先用
Response.Write("生日：" & Birthday)
Response.End

试试把Birthday写出来看看有没有问题吧

[Element]

帮忙顶一下！

[ACMAIN_CHM]

Birthday 估计中空值吧。

[一把编程的菜刀]

直接打印
sql = "select * from kedate where datediff('d',cstr(year(date())) + '-' + cstr(month(Birthday)) + '-' + cstr(day(Birthday)),date()) <="&remindDays &" and datediff('d', cstr(year(date())) + '-' + cstr(month(Birthday)) + '-' + cstr(day(Birthday)),date())>=0 order by ID desc"
Response.Write sql
Response.End

就知道了

[91jk]

谢谢，我自己做出来了