Microsoft JET Database Engine 错误 '80040e07'标准表达式中数据类型不匹配。 house/search_hack.asp，行 106

[zjzb0409]

请高手给详细解释一下 标准表达式中数据类型不匹配。的错误有几种 下边的代码给看看 是否有符号错误 或者什么的 我数据库字段都为 文本格式.... 下边是2块 我感觉能有毛病 小弟找不出来 因为是整站 如果有高手 可以留下联系方式 小弟 要学习..

<%
dim search,search_qy,search_lx,search_hx,search_zj,search_mj_min,search_mj_max,search_jg_min,search_jg_max
search_qy=request("search_qy")
search_lx=request("search_lx")
search_hx=request("search_hx")
search_zj=request("search_zj")
search_mj_min=trim(request("search_mj_min"))
search_mj_max=trim(request("search_mj_max"))
search_jg_min=trim(request("search_jg_min"))
search_jg_max=trim(request("search_jg_max"))

search=""
if request("search_qy")<>"" then
search=search & "and qy='" & request("search_qy") & "'"
end if
if request("search_lx")<>"" then
search=search & " and wylx='" & request("search_lx") & "'"
end if
if request("search_hx")<>"" then
search=search & " and hx='" & request("search_hx") & "'"
end if
if request("search_zj")<>"" then
search=search & " and zj='" & request("search_zj") & "'"
end if
if search_mj_min<>"" then
search=search & " and int(jz_area)>=int(" & search_mj_min & ")"
end if
if search_mj_max<>"" then
search=search & " and int(jz_area)<=int(" & search_mj_max & ")"
end if
if search_jg_min<>"" then
search=search & " and int(pay)>=int(" & search_jg_min & ")"
end if
if search_jg_max<>"" then
search=search & " and int(pay)<=int(" & search_jg_max & ")"
end if

%>



dim pag
%>
<a href="search_hack.asp?pageno=1&search_qy=<%=search_qy%>&search_lx=<%=search_lx%>&search_hx=<%=search_hx%>&search_zj=<%=search_zj%>&search_mj_min=<%=search_mj_min%>&search_mj_max=<%=search_mj_max%>&search_jg_min=<%=search_jg_min%>&search_jg_max=<%=search_jg_max%>" class="menu1">[首页]</a>
<a href="search_hack.asp?pageno=<%=pageno-1%>&search_qy=<%=search_qy%>&search_lx=<%=search_lx%>&search_hx=<%=search_hx%>&search_zj=<%=search_zj%>&search_mj_min=<%=search_mj_min%>&search_mj_max=<%=search_mj_max%>&search_jg_min=<%=search_jg_min%>&search_jg_max=<%=search_jg_max%>" class="menu1">[上一页]</a> <a href="search_hack.asp?pageno=<%=pageno+1%>&search_qy=<%=search_qy%>&search_lx=<%=search_lx%>&search_hx=<%=search_hx%>&search_zj=<%=search_zj%>&search_mj_min=<%=search_mj_min%>&search_mj_max=<%=search_mj_max%>&search_jg_min=<%=search_jg_min%>&search_jg_max=<%=search_jg_max%>" class="menu1">[下一页]</a>
<a href="search_hack.asp?pageno=<%=rs.pagecount%>&search_qy=<%=search_qy%>&search_lx=<%=search_lx%>&search_hx=<%=search_hx%>&search_zj=<%=search_zj%>&search_mj_min=<%=search_mj_min%>&search_mj_max=<%=search_mj_max%>&search_jg_min=<%=search_jg_min%>&search_jg_max=<%=search_jg_max%>" class="menu1">[尾页]</a>
<select name="jump" class="textinput" onChange="javascript:window.open(this.options[this.selectedIndex].value,'_self')">
<% for pag=1 to rs.pagecount
if int(pageno)=pag then %>
<option value="search_hack.asp?pageno=<%=pageno%>&search_qy=<%=search_qy%>&search_lx=<%=search_lx%>&search_hx=<%=search_hx%>&search_zj=<%=search_zj%>&search_mj_min=<%=search_mj_min%>&search_mj_max=<%=search_mj_max%>&search_jg_min=<%=search_jg_min%>&search_jg_max=<%=search_jg_max%>" selected><%=pageno%></option>
<%else%>
<option value="search_hack.asp?pageno=<%=pag%>&search_qy=<%=search_qy%>&search_lx=<%=search_lx%>&search_hx=<%=search_hx%>&search_zj=<%=search_zj%>&search_mj_min=<%=search_mj_min%>&search_mj_max=<%=search_mj_max%>&search_jg_min=<%=search_jg_min%>&search_jg_max=<%=search_jg_max%>"><%=pag%></option>
<%
end if
next %>
</select>
  </td>
</tr>
<% else %>
<tr bgcolor="#FFFFFF">
<td colspan="7" height="458">
<div align="center" class="font">没有数据!</div>
</td>
</tr>
<%
end if
rs.close
set rs=nothing
%>

[dh20156]

%>



dim pag
%>
------------------- ?

• 打赏
• 举报

回复 赞

[yclin2005]

你的代码没用粘贴完！叫人怎样看啊？

• 打赏
• 举报

回复 赞

[zjzb0409]

代码太多 贴不下........ 就是说Microsoft JET Database Engine 错误 '80040e07'标准表达式中数据类型不匹配 这类问题 出错的原因主要是什么?

• 打赏
• 举报

回复 赞

[创造奇迹9999]

106是哪行了

• 打赏
• 举报

回复 赞

[dh20156]

"数据类型不匹配"
检查你的SQL语句中字段对应的变量是否有值，类型是否一致。

• 打赏
• 举报

回复 赞

[yuliang0828]

太长了，狂晕啊～～～

• 打赏
• 举报

回复 赞