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