asp查询条件问题，求帮助？
<%sql1="select*fromAspCms_dingdanwherekuaidi='中通'"setrs1=conn.Execute(sql1)dowhilenot...
<%
sql1 = "select * from AspCms_dingdan where kuaidi='中通'"
set rs1 = conn.Execute (sql1)
do while not rs1.eof
%>
当这样的时候页面显示错误，如果把条件里的中通换成zhongtong就正常了，请问大师怎么破，谢谢！ 展开
sql1 = "select * from AspCms_dingdan where kuaidi='中通'"
set rs1 = conn.Execute (sql1)
do while not rs1.eof
%>
当这样的时候页面显示错误，如果把条件里的中通换成zhongtong就正常了，请问大师怎么破，谢谢！ 展开
1个回答
展开全部
改为
<%
sql1 = "select * from AspCms_dingdan where kuaidi='中通'"
set rs1 = conn.Execute (sql1)
if rs1.eof and rs1.bof then
response.write "暂无查询内容"
else
do while not rs1.eof
......
end id
%>
试下看
<%
sql1 = "select * from AspCms_dingdan where kuaidi='中通'"
set rs1 = conn.Execute (sql1)
if rs1.eof and rs1.bof then
response.write "暂无查询内容"
else
do while not rs1.eof
......
end id
%>
试下看
追问
还是报错，麻烦看下私信，谢谢
本回答由网友推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
