<%
sub SaveAdd
xm=trim(request("xm"))
sfzh=trim(request("sfzh"))
lxdh=trim(request("lxdh"))
dnlx=trim(request("dnlx"))
ppxh=trim(request("ppxh"))
ys=trim(request("ys"))
swfs=trim(request("swfs"))
ffdh=trim(request("ffdh"))
swzh=trim(request("swzh"))
mac1=trim(request("mac1"))
mac2=trim(request("mac2"))
mac3=trim(request("mac3"))
jsjm=trim(request("jsjm"))
ypxlh=trim(request("ypxlh"))
cpuxlh=trim(request("cpuxlh"))
cpxlh=trim(request("cpxlh"))
sydz=trim(request("sydz"))
szdw=trim(request("szdw"))
tbr=trim(request("tbr"))
tbdw=trim(request("tbdw"))
scsj=trim(request("scsj"))
sfbd=trim(request("sfbd"))
set rs=server.createObject("Adodb.recordset")
rs.open sql,conn
' MaxID=rs(0)
rs.close
set rs=nothing
Sql="insert into mac(xm,sfzh,lxdh,dnlx,ppxh,ys,swfs,ffdh,swzh,mac1,mac2,mac3,jsjm,ypxlh,cpuxlh,cpxlh,sydz,szdw,tbr,tbdw,scsj,sfbd) values(" & xm& ",'" & sfzh & "','" & lxdh & "','" & dnlx & "','" & ppxh & "'," & ys & "," & swfs & ",'" &ffdh & "','" & swzh & "','" & mac1 & "','" & mac2 & "','" & mac3 & "','" & ypxlh & "','" & cpuxlh & "','" & sydz & "','" & szdw & "','" & tbr & "','" & tbdw & "','" & scsj & "','" & sfbd & "')"
conn.execute Sql
end sub
%>
上面是网页中插入的代码,但是就是实现不了
还请各位指教啊
sub SaveAdd
xm=trim(request("xm"))
sfzh=trim(request("sfzh"))
lxdh=trim(request("lxdh"))
dnlx=trim(request("dnlx"))
ppxh=trim(request("ppxh"))
ys=trim(request("ys"))
swfs=trim(request("swfs"))
ffdh=trim(request("ffdh"))
swzh=trim(request("swzh"))
mac1=trim(request("mac1"))
mac2=trim(request("mac2"))
mac3=trim(request("mac3"))
jsjm=trim(request("jsjm"))
ypxlh=trim(request("ypxlh"))
cpuxlh=trim(request("cpuxlh"))
cpxlh=trim(request("cpxlh"))
sydz=trim(request("sydz"))
szdw=trim(request("szdw"))
tbr=trim(request("tbr"))
tbdw=trim(request("tbdw"))
scsj=trim(request("scsj"))
sfbd=trim(request("sfbd"))
set rs=server.createObject("Adodb.recordset")
rs.open sql,conn
' MaxID=rs(0)
rs.close
set rs=nothing
Sql="insert into mac(xm,sfzh,lxdh,dnlx,ppxh,ys,swfs,ffdh,swzh,mac1,mac2,mac3,jsjm,ypxlh,cpuxlh,cpxlh,sydz,szdw,tbr,tbdw,scsj,sfbd) values(" & xm& ",'" & sfzh & "','" & lxdh & "','" & dnlx & "','" & ppxh & "'," & ys & "," & swfs & ",'" &ffdh & "','" & swzh & "','" & mac1 & "','" & mac2 & "','" & mac3 & "','" & ypxlh & "','" & cpuxlh & "','" & sydz & "','" & szdw & "','" & tbr & "','" & tbdw & "','" & scsj & "','" & sfbd & "')"
conn.execute Sql
end sub
%>
上面是网页中插入的代码,但是就是实现不了
还请各位指教啊
解决方案 »
- 使用updatepanel后执行后台方法失去焦点后。。。。
- ==双机备份的情况呀,如何解决用户数据共享==
- 动态设定SqlDataSource的SelectCommand后gridview分页的问题
- 帮看下这个项目,该如何提高web服务器访问速度
- javascript添加select的option在服务器端如何读取 急!!!
- 0分,求权限的单词!!千万不能鄙视!
- javascript 取参数问题
- MVC的Controller中的Action如何向aspx视图引擎传递参数
- iBATIS.net获取运行时sql语句(带参数)
- wpf中word文件转xps文件报转换后的xps文件路径找不到
- XAF框架下的左侧目录树实现??
- 求一句SQL语句
打开了一个未知的语句
rs.open sql,conn
' MaxID=rs(0)
rs.close
set rs=nothing
把这段去掉
再不行的话你response.write(Sql)把输入的语句复制到查询分析器里执行一下,看看有没有错了
提示这句有错误,少then
我运行没什么错误,
还希望哪位能指导一下