华莱士一个月赚多少:"标准表达式中数据类型不匹配"我明明用的文本类型,输入也是文本的呀。

来源:百度文库 编辑:高校问答 时间:2024/05/05 15:51:39
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e07'

[Microsoft][ODBC Microsoft Access Driver] 标准表达式中数据类型不匹配。

/grow/add.asp,行83

我把要输入的地方改成文本就好了。
出错地方代码:

<%
If Request("Name")<>"" and Request("Type")<>"" and Request("Output")<>"" and Request("Price")<>"" and Request("Seed_demand")<>"" and Request("Seed_price")<>"" and Request("Cost")<>"" and Request("Alias")<>"" and Request("Genus")<>"" and Request("Summarize")<>"" and Request("Modality")<>"" and Request("Habit")<>"" and Request("Technic")<>"" and Request("Prevent")<>"" and Request("Reap")<>"" Then
'头部已经包含数据库连结
Dim strSql,varName,varTyp,varSummarize
varName=Request("name") '这里也可以不定义变量,下面直接用Request("Name")
varTyp=Request("Type")
varOutput=Request("Output")
varPrice=Request("Price")
varSeed_demand=Request("Seed_demand")
varSeed_price=Request("Seed_price")
varCost=Request("Cost")
varAlias=Request("Alias")
varGenus=Request("Genus")
varSummarize=Request("Summarize")
varModality=Request("Modality")
varHabit=Request("Habit")
varTechnic=Request("Technic")
varPrevent=Request("Prevent")
varReap=Request("Reap")
StrSql="insert into info(name,Type,Output,Price,Seed_demand,Seed_price,Cost,Alias,Genus,Summarize,Modality,Habit,Technic,Prevent,Reap,submit_date) values('" & varName & "','" & varTyp & "','" & varOutput & "','" & varSummarize & "','" & varPrice & "','" & varSeed_demand & "','" & varSeed_price & "','" & varCost & "','" & varAlias & "','" & varGenus & "','" & varSummarize & "','" & varModality & "','" & varHabit & "','" & varPrevent & "','" & varReap & "','" & Date() & "')" '这里Date()是取系统时间
conn.execute(strSql) '添加记录 这是83行。
Response.Redirect "show.asp" '添加完毕,返回首页show.asp
Else
Response.Write "把所有信息填写完整再提交!"
End If
%>