28,390
社区成员
发帖
与我相关
我的任务
分享我晕~~~_________数据参数不够
技术信息（用于支持人员）
错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] 参数不足，期待是 1。
/ty_sb_save.asp, 第 31 行
浏览器类型：
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)
网页：
POST 140 ??? /ty_sb_save.asp
POST Data:
name=1&ll=12&yc=12&gl=12&zl=12&cz=12312&zzs=1qew&ghs=qr&ycd=rq&dj=qrw&hl=qr&date_y=2003&date_m=7&date_d=1&sygc=ff&memo=ffqr&B1=%C8%B7+%B6%A8
错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] 参数不足，期待是 1。
/ty_sb_save.asp, 第 31 行
浏览器类型：
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)
网页：
POST 140 ??? /ty_sb_save.asp
POST Data:
name=1&ll=12&yc=12&gl=12&zl=12&cz=12312&zzs=1qew&ghs=qr&ycd=rq&dj=qrw&hl=qr&date_y=2003&date_m=7&date_d=1&sygc=ff&memo=ffqr&B1=%C8%B7+%B6%A8
...全文
请发表友善的回复…
发表回复
bubuy 2003-07-01
- 打赏
- 举报
你把sql语句打印出来到查询分析器里调试一下。
还有，你这里面有日期型的没？？
(名称,流量,扬程,功率,重量,材质,制造商,供货商,原产地,单价,汇率,报价时间,所应用工程,备注)
还有，你这里面有日期型的没？？
(名称,流量,扬程,功率,重量,材质,制造商,供货商,原产地,单价,汇率,报价时间,所应用工程,备注)
bubuy 2003-07-01
- 打赏
- 举报
你的sql语句有问题
zcwmxn 2003-07-01
- 打赏
- 举报
————————dbconn.asp————————
<%@ Language=VBScript %>
<%option explicit%>
<%
public function GetConnStr()
GetConnStr="driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("db.mdb")
end function
'打开数据库连接
public Function dbConnOpen()
dim conn,hkrcom
set conn=server.CreateObject("ADODB.Connection")
conn.Open GetConnStr()
set dbConnOpen=conn
end Function
%>
<%@ Language=VBScript %>
<%option explicit%>
<%
public function GetConnStr()
GetConnStr="driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("db.mdb")
end function
'打开数据库连接
public Function dbConnOpen()
dim conn,hkrcom
set conn=server.CreateObject("ADODB.Connection")
conn.Open GetConnStr()
set dbConnOpen=conn
end Function
%>
zcwmxn 2003-07-01
- 打赏
- 举报
———————————ty_sb_save.asp————————————
<!--#include file="dbconn.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>添加记录</title>
</head>
<link rel="stylesheet" href="css/text.css" type="text/css">
<body>
<%
dim name,ll,yc,gl,zl,cz,zzs,ghs,ycd,dj,hl,pdate,sygc,memo
name = request.form("name")
ll = trim(request.form("ll"))
yc = trim(request.form("yc"))
gl = trim(request.form("gl"))
zl = trim(request.form("zl"))
cz = trim(request.form("cz"))
zzs = trim(request.form("zzs"))
ghs = trim(request.form("ghs"))
ycd = trim(request.form("ycd"))
dj = trim(request.form("dj"))
hl = trim(request.form("hl"))
pdate = trim(request.form("date_y"))&"-"&trim(request.form("date_m"))&"-"&trim(request.form("date_d"))
sygc = trim(request.form("sygc"))
memo = trim(request.form("memo"))
dim conn,rst,strsql
set conn=dbConnOpen()
'Set rst=Server.CreateObject("ADODB.RecordSet")
strsql="insert into ty_sb (名称,流量,扬程,功率,重量,材质,制造商,供货商,原产地,单价,汇率,报价时间,所应用工程,备注) values ('"&name&"',"&ll&","&yc&","&gl&","&zl&",'"&cz&"','"&zzs&"','"&ghs&"','"&ycd&"','"&dj&"',"&hl&",'"&pdate&"','"&sygc&"','"&memo&"')"
response.write strsql
conn.execute(strsql)
response.write "操作成功<br><a href='price_add.asp'>继续添加</a>"
response.end
%>
<!--#include file="dbconn.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>添加记录</title>
</head>
<link rel="stylesheet" href="css/text.css" type="text/css">
<body>
<%
dim name,ll,yc,gl,zl,cz,zzs,ghs,ycd,dj,hl,pdate,sygc,memo
name = request.form("name")
ll = trim(request.form("ll"))
yc = trim(request.form("yc"))
gl = trim(request.form("gl"))
zl = trim(request.form("zl"))
cz = trim(request.form("cz"))
zzs = trim(request.form("zzs"))
ghs = trim(request.form("ghs"))
ycd = trim(request.form("ycd"))
dj = trim(request.form("dj"))
hl = trim(request.form("hl"))
pdate = trim(request.form("date_y"))&"-"&trim(request.form("date_m"))&"-"&trim(request.form("date_d"))
sygc = trim(request.form("sygc"))
memo = trim(request.form("memo"))
dim conn,rst,strsql
set conn=dbConnOpen()
'Set rst=Server.CreateObject("ADODB.RecordSet")
strsql="insert into ty_sb (名称,流量,扬程,功率,重量,材质,制造商,供货商,原产地,单价,汇率,报价时间,所应用工程,备注) values ('"&name&"',"&ll&","&yc&","&gl&","&zl&",'"&cz&"','"&zzs&"','"&ghs&"','"&ycd&"','"&dj&"',"&hl&",'"&pdate&"','"&sygc&"','"&memo&"')"
response.write strsql
conn.execute(strsql)
response.write "操作成功<br><a href='price_add.asp'>继续添加</a>"
response.end
%>
