<!--#include file="conn.asp"-->
<%
dim id
id=cint(request.querystring("id"))
set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from y_order where id="&id ,conn,1,3
rs("id")=trim(request("id"))
rs("y_orderid")=trim(request("y_orderid"))
rs("y_noteid")=trim(request("y_noteid"))
rs("y_num")=trim(request("y_num"))
rs("y_xprice")=trim(request("y_xprice"))
rs("y_airways")=trim(request("y_airways"))
rs("y_other")=trim(request("y_other"))
rs("y_price")=trim(request("y_price"))
rs("y_hprice")=trim(request("y_hprice"))
rs("y_hortation")=trim(request("y_hortation"))
rs("y_sharp1")=trim(request("y_sharp1"))
rs("y_sharp")=trim(request("y_sharp"))
rs("y_number")=trim(request("y_number"))
rs("y_oughtfee")=trim(request("y_oughtfee"))
rs("y_dprice")=trim(request("y_dprice"))
rs("y_margin")=trim(request("y_margin"))
rs("y_downpeople")=trim(request("y_downpeople"))
rs("y_manager")=trim(request("y_manager"))
rs("y_invoicename")=trim(request("y_invoicename"))
rs("y_invoiceprice")=trim(request("y_invoiceprice"))
rs("y_address")=trim(request("y_address"))
rs("y_bank")=trim(request("y_bank"))
rs("y_phone")=trim(request("y_phone"))
rs("y_people1")=trim(request("y_people1"))
rs("y_touchpeople")=trim(request("y_touchpeople"))
rs("y_people2")=trim(request("y_people2"))
rs("y_handsetnum")=trim(request("y_handsetnum"))
rs("y_people3")=trim(request("y_people3"))
rs("y_leavedate")=trim(request("y_leavedate"))
rs("y_journey")=trim(request("y_journey"))
rs("y_remark")=trim(request("y_remark"))
rs.Update
rs.Close
set rs=nothing
response.Write "<script language=javascript>alert('修改成功！');history.go(-1);</script>"
response.End
%>
一点"修改"就报错
我都
了
错误类型：
Microsoft JET Database Engine (0x80040E14)
语法错误 (操作符丢失) 在查询表达式 'id=' 中。
/airjipiao/updatesuc.asp, 第 4 行
哪位高手大哥帮帮忙看一下
[此贴子已经被作者于2006-11-7 10:13:25编辑过]
