[求助]请帮忙看看这个查询语句有误吗？ - ASP技术论坛

肖走

等　级：新手上路
帖　子：85
专家分：0
注　册：2005-9-26

第 2 楼

得分:0

数据是从前面ASP页的表单传递来的，而且正确传递了，但是就查不到结果，明明数据库中是有对应结果的！

2005-10-16 20:17

肖走

等　级：新手上路
帖　子：85
专家分：0
注　册：2005-9-26

第 4 楼

得分:0

<html>

<head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <title>高级查询结果</title> </head>

<% wyear=request.form("年") wmon=request.form("月") wday=request.form("日") wsite=request.form("TID") wcond=request.form("condition") wcl=request.form("处理人") wcom=request.form("客户名称")

Response.Write wyear Response.Write wmon Response.Write wday Response.Write wsite Response.Write wcond Response.Write wcl Response.Write wcom

Set rs = Server.CreateObject ("ADODB.Recordset") sql="Select * from gzhz where 年="&wyear&""

if wmon<>"请选择" then sql=sql&" and 月="&wmon&"" end if if wday<>"请选择" then sql=sql&" and 日="&wday&"" end if if wsite<>"请选择" then sql=sql&" and (TID1='"&wsite&"' or TID2='"&wsite&"')" end if if wcond<>"请选择" then sql=sql&" and condition='"&wcond&"'" end if if wcom<>"请选择" then sql=sql&" and 客户名称='"&wcom&"'" end if rs.Open sql,conn,1,2 %>

<% dim gzcount gzcount=rs.RecordCount %> <tr bgcolor=#006c6c> <td colspan=<%=rs.Fields.Count+1 %>.><%Response.Write "共"&gzcount&"条纪录当前时间"&CStr(now)&""%></td> </tr> <tr bgcolor="#ffffaf"> <% for i=0 to rs.Fields.Count-24 Response.Write "<td align=center nowrap>ID号</td>" Next FOR i=1 to rs.Fields.Count-23 Response.Write "<td align=center nowrap>开始日期</td>" Next FOR i=2 to rs.Fields.Count-22 Response.Write "<td align=center nowrap>结束日期</td>" Next FOR i=3 to rs.Fields.Count-21 Response.Write "<td align=center nowrap>发生时间段</td>" Next FOR i=11 to rs.Fields.Count-13 Response.Write "<td align=center nowrap>"&Ucase(rs(i).Name)&"(分钟)</td>" Next FOR i=12 to rs.Fields.Count-1 Response.Write "<td align=center nowrap>"&Ucase(rs(i).Name)&"</td>" Next %> </tr>

<% '输出内容 Do While NOT rs.EOF Response.Write "<tr>" for i=0 to rs.Fields.Count-24 Response.Write "<td align=center nowrap>"&Ucase(rs(i).Value)&"</td>" Next FOR i=1 to rs.Fields.Count-23 Response.Write "<td align=center nowrap>"&Ucase(rs(1).Value&"-"&rs(2).Value&"-"&rs(3).Value)&"</td>" Next FOR i=2 to rs.Fields.Count-22 Response.Write "<td align=center nowrap>"&Ucase(rs(4).Value&"-"&rs(5).Value&"-"&rs(6).Value)&"</td>" Next FOR i=3 to rs.Fields.Count-21 Response.Write "<td align=center nowrap>"&Ucase(rs(7).Value&":"&rs(8).Value&"-"&rs(9).Value&":"&rs(10).Value)&"</td>" Next FOR i=11 to rs.Fields.Count-1 Response.Write "<td align=center nowrap>"&rs(i).Value&"</td>" Next rs.MoveNext Response.Write "</tr>"

Loop Response.Write"</table>" %>

<% rs.close Set rs = Nothing conn.close set conn=Nothing %> </body>

</html> 这是整个程序了，我实在是找不出有什么问题了，大虾给检查检查吧！我用Response.Write wyear检查了，表单能正确传递过来的！

2005-10-16 20:44

肖走

等　级：新手上路
帖　子：85
专家分：0
注　册：2005-9-26

第 6 楼

得分:0

没有，经检查Response.Write (""&rs.Fields.Count&"")结果是24，没错！因为我的数据库有24列，所以才这样写，这个没有问题的，我其他页面这么写都正常的！

[此贴子已经被作者于2005-10-16 21:41:57编辑过]

2005-10-16 21:38