帮忙看一下，哪里错了~~

[kindss]

Sub upd
Dim u_bianhao, u_qidian, u_zhongdian, u_chexing, u_checi, u_facheshijian, u_fangxiang, u_note
u_bianhao = Trim(Request.Form("u_bianhao"))
u_qidian = Trim(Request.Form("u_qidian"))
u_zhongdian = Trim(Request.Form("u_zhongdian"))
u_chexing = Trim(Request.Form("u_chexing"))
u_checi = Trim(Request.Form("u_checi"))
u_facheshijian = Trim(Request.Form("u_facheshijian"))
u_fangxiang = Trim(Request.Form("u_fangxiang"))
u_note = Trim(Request.Form("u_note"))

MM_editQuery = "UPDATE [checi] SET " & _
"bianhao = " & to_sql(u_bianhao,"number") & ", " & _
"qidian = " & to_sql(u_qidian,"text") & ", " & _
"zhongdian = " & to_sql(u_zhongdian,"text") & ", " & _
"chexing = " & to_sql(u_chexing,"text") & ", " & _
"checi = " & to_sql(u_checi,"text") & ", " & _
"facheshijian = " & to_sql(u_facheshijian,"text") & ", " & _
"fangxiang = " & to_sql(u_fangxiang,"number") & ", " & _
"note = " & to_sql(u_note,"text") & " WHERE " & _
"bianhao = " & to_sql(u_bianhao,"number") & ""

Set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = MM_conn_STRING
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close
End sub

[tweeg_nee]

出错信息呢？贴出来啊

[kindss]

调试:
UPDATE [checi] SET qidian = '厦门', zhongdian = '西安', chexing = '快速、有空调', checi = 'K244次', facheshijian = '14:18', fangxiang = 0, note = 'afdsf' WHERE bianhao = 8

Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'

[Microsoft][ODBC Microsoft Access 驱动程序] UPDATE 语句的语法错误。

/admin/train_main.asp, 行89

[pp4u]

没发现，是不是字段拼写错误？

[conner]

1。看一下字段类型是否匹配，
2。字段长度是否够用
3。看看是否是某个字段不允许为空，但是你没有传入字符

或者直接在查询分析器里执行一下以下代码，看看报什么错误
UPDATE [checi] SET qidian = '厦门', zhongdian = '西安', chexing = '快速、有空调', checi = 'K244次', facheshijian = '14:18', fangxiang = 0, note = 'afdsf' WHERE bianhao = 8

[xiaobaowu]

把表名前后的中括号去掉试试。
UPDATE chec] SET qidian = '厦门', zhongdian = '西安', chexing = '快速、有空调', checi = 'K244次', facheshijian = '14:18', fangxiang = 0, note = 'afdsf' WHERE bianhao = 8

[xiaobaowu]

sorry，上面的发错了。
UPDATE chec SET qidian = '厦门', zhongdian = '西安', chexing = '快速、有空调', checi = 'K244次', facheshijian = '14:18', fangxiang = 0, note = 'afdsf' WHERE bianhao = 8

[xiaobaowu]

唉，今天是眼花了，又少写了一个i
UPDATE checi SET qidian = '厦门', zhongdian = '西安', chexing = '快速、有空调', checi = 'K244次', facheshijian = '14:18', fangxiang = 0, note = 'afdsf' WHERE bianhao = 8

[甘泉123]

MM_editQuery = "UPDATE [checi] SET " & _
"bianhao = " & to_sql(u_bianhao,"number") & ", " & _
"qidian = " & to_sql(u_qidian,"text") & ", " & _
"zhongdian = " & to_sql(u_zhongdian,"text") & ", " & _
"chexing = " & to_sql(u_chexing,"text") & ", " & _
"checi = " & to_sql(u_checi,"text") & ", " & _
"facheshijian = " & to_sql(u_facheshijian,"text") & ", " & _
"fangxiang = " & to_sql(u_fangxiang,"number") & ", " & _
"note = " & to_sql(u_note,"text") & " WHERE " & _
"bianhao = " & to_sql(u_bianhao,"number") & ""
编号还用set吗？？逻辑好象有问题~

[剑心]

首先编号若是自动编号的话，这个就不能再写了，不然肯定出错

另外字段要对应，若是数字，则不能要引号

还有是字符必须用引号，不然肯定出错

具体调试思路：

首先打出来sql语句，看看有没有问题

然后查看数据库是否为可写
（在权限属性里查看）

最后就是缩减代码，使用最小集合。看看又没有问题，然后逐句添加完善。

[deyen]

bianhao 数字|长整型
qidian 文本
zhongdian 文本
chexing 文本
checi 文本
facheshijian 文本
fangxiang 数字|字节
note 文本
================================
bianhao 不是自动编号，是为了便于修改,同时是另一个表的关联字段

[jie115]

更新 所有的纪录?

[xupiao]

我建議你一次不要更新那麼多字段(兩個兩個的中上)
這樣你就可找到到底是那一字段有問題

調試嘛

[kindss]

找到原因了，:P都过了好多天了。

原来是那个 "note" 惹的祸，是个保留字还是什么的？

改了就OK了。