主题:[求助]
各位前辈帮忙看看,我编的一段函数代码,运行时总是说[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 'user= and recordYear=2008and recordMonth=1and recordDay=4' 中。到论著错哪儿了?代码如下:
Function checksysIswork() '用户登录检查
sql = "select * from kaoqing_table where user="&Session("username")&" and recordYear="&Year(Now())&"and recordMonth="&Month(Now())&"and recordDay="&Day(Now())&""
Set rs1=Conn.execute(Sql)
if Iswork=1 then
checksysIswork=FALSE
Else
checksysIswork=TRUE
End if
Conn.execute(Sql)
End Function
Function checksysIswork() '用户登录检查
sql = "select * from kaoqing_table where user="&Session("username")&" and recordYear="&Year(Now())&"and recordMonth="&Month(Now())&"and recordDay="&Day(Now())&""
Set rs1=Conn.execute(Sql)
if Iswork=1 then
checksysIswork=FALSE
Else
checksysIswork=TRUE
End if
Conn.execute(Sql)
End Function