帮我看看我 的SQL语句那里出错 了，我实在是找不到了，都看晕了，
SQL=UPDATE [t_goods] SET [goods_code]='"& goods_code &"',[goods_name]='"& goods_name &"',[brand_code]="& brand_code &",[provider]='"& providers &"',[goods_number] ="& goods_number &",[goods_weight]="& goods_weight &" ,[market_price]="& market_price &",[shop_price]="shop_price",[promote_price] ="& promote_price &",[promote_start_date]='"& promote_start_date & "',[promote_end_date]='"& promote_end_date &"' ,[warn_number]="& warn_number &",[goods_keywords]='"& goods_keywords &"',[goods_img]='"& goods_img &"',[is_real] ="& is_real &",[is_on_sale]="& is_on_sale &",[add_time]='"& add_time &"',[is_delete] ="& is_delete &",[is_best] ="& is_best &",[is_new] ="& is_new &",[is_hot] ="& is_hot &",[is_promote]="& is_promote &",[goods_type_code] ="& goods_type_code &",[seller_note]='"& seller_note &"',[goods_describe]='"& goods_describe &"',[color]='"& color &"',[chima]='"& chima &"',[webtitle]='"&webtitle&"',[webkeyword]='"&webkeyword&"',[webdescription]='"&webdescription&"' WHERE goods_id="& goods_id这是ａｓｐ里的老显示语句未结束，请各位大哥帮下忙啊。
