!!!!!!!update语句更新数据库问题?大家看看问题出在那里?
我想要更新USER表里的alogouttime和atotaltime,运行页面时没有提示错,但这两个字段却没有更新,看了半天也不知道是那写错了;大家帮忙看看问题在那?谢谢!
conn.execute( "update User set alogouttime= "&now()& ",atotaltime=atotaltime + "&datedIff( "n ",session( "starttimes "),Now())& " where username= ' "&session( "username ")& " ' ")
------解决方案--------------------conn.execute( "update [User] set alogouttime= ' "&now()& " ',atotaltime=atotaltime + "&datedIff( "n ",session( "starttimes "),Now())& " where username= ' "&session( "username ")& " ' ")