[code=JScrip] if request.form("oper") = "channelUpdate" then
set cmd.ActiveConnection=cn
cmd.CommandText="{call proc_channelUpdate_for_admin(?,?,?,?,?,?,?,?,?,?,?)}"
cmd.Parameters.Append cmd.CreateParameter("@c_id",adInteger,adParamInput)
cmd("@c_id")=request.Form("c_id")
cmd.Parameters.Append cmd.CreateParameter("@c_name",adVarChar,adParamInput,40 )
cmd("@c_name")=request.form("c_name")
cmd.Parameters.Append cmd.CreateParameter("@u_loginname",adVarChar,adParamInput,20 )
cmd("@u_loginname")=request.form("u_loginname")
cmd.Parameters.Append cmd.CreateParameter("@u_pass",adVarChar,adParamInput,32 )
cmd("@u_pass")=request.form("u_pass")
cmd.Parameters.Append cmd.CreateParameter("@p_startnum",adInteger,adParamInput)
cmd("@p_startnum")=request.form("p_startnum")
cmd.Parameters.Append cmd.CreateParameter("@p_endnum",adInteger,adParamInput)
cmd("@p_endnum")=request.form("p_endnum")
cmd.Parameters.Append cmd.CreateParameter("@p_mobileservice",adVarChar,adParamInput,60)
cmd("@p_mobileservice")=request.form("p_mobileservice")
cmd.Parameters.Append cmd.CreateParameter("@p_unicomservice",adVarChar,adParamInput,60)
cmd("@p_unicomservice")=request.form("p_unicomservice")
cmd.Parameters.Append cmd.CreateParameter("@p_telecomservice",adVarChar,adParamInput,60 )
cmd("@p_telecomservice")=request.form("p_telecomservice")
cmd.Parameters.Append cmd.CreateParameter("@p_mobilefeevalue",adInteger,adParamInput)
cmd("@p_mobilefeevalue")=request.form("p_mobilefeevalue")
cmd.Parameters.Append cmd.CreateParameter("@p_unicomfeevalue",adInteger,adParamInput)
cmd("@p_unicomfeevalue")=request.form("p_unicomfeevalue")
cmd.Parameters.Append cmd.CreateParameter("@p_telecomfeevalue",adInteger,adParamInput)
cmd("@p_telecomfeevalue")=request.form("p_telecomfeevalue")
cmd.Parameters.Append cmd.CreateParameter("@result",adVarChar,adParamOutput,50) cmd.Execute() result=cmd("@result")
'response.Write(result)
response.Redirect("submit_confirm.asp?operResult="&result)
end if[/code]
set cmd.ActiveConnection=cn
cmd.CommandText="{call proc_channelUpdate_for_admin(?,?,?,?,?,?,?,?,?,?,?)}"
cmd.Parameters.Append cmd.CreateParameter("@c_id",adInteger,adParamInput)
cmd("@c_id")=request.Form("c_id")
cmd.Parameters.Append cmd.CreateParameter("@c_name",adVarChar,adParamInput,40 )
cmd("@c_name")=request.form("c_name")
cmd.Parameters.Append cmd.CreateParameter("@u_loginname",adVarChar,adParamInput,20 )
cmd("@u_loginname")=request.form("u_loginname")
cmd.Parameters.Append cmd.CreateParameter("@u_pass",adVarChar,adParamInput,32 )
cmd("@u_pass")=request.form("u_pass")
cmd.Parameters.Append cmd.CreateParameter("@p_startnum",adInteger,adParamInput)
cmd("@p_startnum")=request.form("p_startnum")
cmd.Parameters.Append cmd.CreateParameter("@p_endnum",adInteger,adParamInput)
cmd("@p_endnum")=request.form("p_endnum")
cmd.Parameters.Append cmd.CreateParameter("@p_mobileservice",adVarChar,adParamInput,60)
cmd("@p_mobileservice")=request.form("p_mobileservice")
cmd.Parameters.Append cmd.CreateParameter("@p_unicomservice",adVarChar,adParamInput,60)
cmd("@p_unicomservice")=request.form("p_unicomservice")
cmd.Parameters.Append cmd.CreateParameter("@p_telecomservice",adVarChar,adParamInput,60 )
cmd("@p_telecomservice")=request.form("p_telecomservice")
cmd.Parameters.Append cmd.CreateParameter("@p_mobilefeevalue",adInteger,adParamInput)
cmd("@p_mobilefeevalue")=request.form("p_mobilefeevalue")
cmd.Parameters.Append cmd.CreateParameter("@p_unicomfeevalue",adInteger,adParamInput)
cmd("@p_unicomfeevalue")=request.form("p_unicomfeevalue")
cmd.Parameters.Append cmd.CreateParameter("@p_telecomfeevalue",adInteger,adParamInput)
cmd("@p_telecomfeevalue")=request.form("p_telecomfeevalue")
cmd.Parameters.Append cmd.CreateParameter("@result",adVarChar,adParamOutput,50) cmd.Execute() result=cmd("@result")
'response.Write(result)
response.Redirect("submit_confirm.asp?operResult="&result)
end if[/code]
解决方案 »
- 一个由图片组成的页面,jQuery无法获得页面正确文档高度
- WebBrowser1.ExecWB(7,1)打印预览后如何关闭页面?
- 基于EXT4.0桌面组件开发的多系统切换WEB框架
- ctrl+回车提交表单的问题
- 求助~~~~~HTML的格式问题!指点一下
- 在IE6.0的浏览器下select控件支持selected属性吗
- 页面 submit 后,js 怎么能检测到页面的处理事件完成
- jjavascript 在win7的IE9不能正常显示?求解!急
- 如何得到父框架的主机名(域名)
- 请教高手一些问题!
- 如何通过坐标得到Dom元素
- 不显示删除回复显示所有回复显示星级回复显示得分回复 html 用js直接加载webservice xml对象,list对象
猜想:是否是因为request.form获取空值而存储过程中的参数为非空参数你可以把报的错显示出来看看,什么错误