日期:2014-05-17  浏览次数:21159 次

!!!!!!!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 ")& " ' ")