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