在线急等，解决就给分，一个简单的sql语句

[zyh791211]

我想同时更新两个字断值，这样写
sql="update tb_doc_send set drafter='lzd' and doc_state=7 where id="&doc_id
好象不对啊，谁有对的写出来。

[mikespook]

sql="update tb_doc_send set drafter='lzd' and doc_state=7 where id="&doc_id
把AND换成逗号~
sql="update tb_doc_send set drafter='lzd' ，doc_state=7 where id="&doc_id

[fason]

and => ,

[tacchan]

sql="update tb_doc_send set drafter='lzd' , doc_state=7 where id="&doc_id

[myvicy]

and换逗号,

[xiaoyao888]

sql="update tb_doc_send set drafter='lzd',doc_state=7 where id="&doc_id