用execute如何update时间dnow()toconn.execute( updateorderlistsetsaledate &d& whereinfo_id &in
用execute如何update时间
d=now()
toconn.execute( "update orderlist set saledate= "&d& " where info_id= "&infoid)
说格式错误
[解决办法]
toconn.execute( "update orderlist set saledate= ' "& now() & " ' where info_id= "&infoid)
[解决办法]
d= " ' "&now()& " ' "
这样就行了
如果这个不行,就试试
d=now()
toconn.execute( "update orderlist set saledate=# "&d& "# where info_id= "&infoid)