asp中关于access数字字段的更新。conn.execute update PriceSpotTable set BuyScoreBuyScore+&snums& w
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