怎么SQL语句有错误呢？各位帮忙看看！！！

2005-01-26 10:27:02 113 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Brim与ZUI协同安装指南：从下载到流量分析实战本文提供Brim与ZUI协同安装与实战指南，详细讲解从下载、环境变量配置到流量分析的全流程。通过将PCAP文件转换为ZNG格式，结合直观的Zed查询语言，这套组合能极大提升大型网络数据包的分析效率，是网络安全与运维人员进行高效流量分析的利器。阅读详情

sCmd = "update authors"
sCmd = sCmd + "set"
sCmd = sCmd + "au_id='" + Trim(txtId.Text) + "'"
sCmd = sCmd + ",au_fname='"+ Trim(txtFirstName.Text) + "'"
sCmd = sCmd + ",au_lname='" + Trim(txtLastName.Text) + "'"
sCmd = sCmd + ",address='" + Trim(txtAddress.Text) + "'"
sCmd = sCmd + ",city='" + Trim(txtCity.Text) + "'"
sCmd = sCmd + ",state='" + Trim(txtState.Text) + "'"
sCmd = sCmd + ",zip='" + Trim(txtZip.Text) + "'"
sCmd = sCmd + ",phone='" + Trim(txtPhone.Text) + "'"
sCmd = sCmd + ",contract=" & IIf(chkContract.Value = vbChecked, 1, 0)
sCmd = sCmd + "where au_id='" + msCurrentRecord +"'

On Error GoTo UpDatefailed:
mConn.Execute sCmd

老是提示说第一巷”=“附近有错误？？？

...全文