sql2000这样的语句更新不了。。。

rs_zhaopin.open"select * from xueyuanfaduanxink where xueyuan = '戴丞' and fasongzhuantai= 0 order by id desc",conn_zhaopin,1,3
         
       rs_zhaopin("fasongzhuantai") = 1
       rs_zhaopin.update
    rs_zhaopin.close

该怎么写呢　？