asp中关于access数字字段的更新。
conn.execute "update PriceSpotTable set BuyScore=BuyScore+"&snums&" where SpotID="uid

BuyScore为数字字段，想在原数据基础上加snums，为什么这样写会出错，

------解决方案--------------------
后边少了一个 & 号

conn.execute "update PriceSpotTable set BuyScore=BuyScore+"&snums&" where SpotID=" & uid