错误号:-2147217913,错误描述:日期的语法错误 在查询表...
问:错误号:-2147217913,错误描述:日期的语法错误 在查询表达式 'TimeStatus=1 and Timeing <= #2012-5-22 下午 09:47:22#' 中。sql=update AspCms_Content set TimeStatus=0 where TimeStatus=1 and Timeing <= #2012-5-22 下午 09:47:22#答:修改inc目录下AspCms_CommonFun.asp的第191行:
conn.exec "update {prefix}Content set TimeStatus=0 where TimeStatus=1 and Timeing <= #" & now()&"#","exe"
修改为:
conn.exec "update {prefix}Content set TimeStatus=0 where TimeStatus=1 and Timeing <= #" & date()&"#","exe"
页:
[1]