my_sql update语句 急help 在线等
dim fen
fen = 20000
hlwzrs.open "update pchat_user set nBean = nBean+4000000 where uin= "&menberrs.fields( "id "),mysqlcon,1,3
这样是能够实现的
可是把4000000改成变量(fen)就不行．．为什么？
达人给个正确答案．．．．
[解决办法]
hlwzrs.open "update pchat_user set nBean = nBean+ " & fen & " where uin= "&menberrs.fields( "id "),mysqlcon,1,3
