在網站留言頁面上增加了一個日歷，如何實現點擊相應時間，即可查到當日的留言？

下面是實現方法：

1、將以下代碼保存為calendar.asp，放入到GuestBook目錄下

<style>
    html,body{margin:5px 0px 0px 0px;height:100%;font-size:9pt}
    td { font-family: "宋體"; font-size:9pt}
</style>
<table width="180" cellpadding="0" cellspacing="1" bgcolor="dddddd" align=center>
<%
   '以下為ASP中通過該日歷算法實現的具體代碼
   '先判斷是否指定了一個年份和月份，沒有則根據當前的年和月份顯示
    If Request("ReqDate")="" then
         CurrentDate=Date
    else
         CurrentDate=Trim(Request("ReqDate"))
    end if 
    pyear=year(CurrentDate)
    pmonth=month(CurrentDate)
 
    '以下的代碼生成日歷顯示的表格頭內容
%>
  <tr align="LEFT" bgcolor="#dddddd"> 
       <td width="14%" height="19" align="center">
           <input type="button" value="<<" onClick="JavaScript:location.href='?ReqDate=<%=DateAdd("m",-1,CurrentDate) %>'">
      </td>
     <td colspan="5" align="center">
        <%=pyear%>年<%=pmonth%>月
     </td>
     <td width="14%" align="center">
        <input type="button" value=">>" onClick="JavaScript:location.href='?ReqDate=<%=DateAdd("m",1,CurrentDate)%>'">
     </td>
  </tr>
  <tr align="center" bgcolor="#CCCCCC"> 
    <td width="14%" height="19"> 日</td>
    <td width="14%"> 一</td>
    <td width="14%"> 二</td>
    <td width="14%"> 三</td>
    <td width="14%"> 四</td>
    <td width="14%"> 五</td>
    <td width="14%"> 六</td>
  </tr>
  <tr align=center bgcolor=ffffff height=19>
  <%
  '由于ASP中沒有獲取指定月共有多少天的函數，因此我們需要通過其他算法來獲得，算法其實很簡單，就是計算一下要顯示月份的1日至下個月的1日一共相差幾天
    fromDate = FormatDateTime(month(CurrentDate) & "/1/" &  year(CurrentDate)) 
    toDate = FormatDateTime(DateAdd("m",1,fromDate)) 
    '獲得要顯示月份的第一天為周幾
    nunmonthstart=weekday(fromDate)-1
    '獲得要顯示的1日至下個月的1日一共相差幾天(月份一共有多少天)
    nunmonthend=DateDiff("d",fromDate,toDate)
    '判斷顯示日歷需要用幾行表格來顯示（每行顯示7天）
    if nunmonthstart+nunmonthend<36 then
         maxi=36
    else
         maxi=43
    end if
    '循環生成表格并顯示
    i=1
    do while i<maxi
        iv=i-nunmonthstart
        if   i>nunmonthstart and i<=nunmonthend+nunmonthstart then
            '如果為顯示的是今天則用紅色背景顯示
            if  iv=Day(now) and month(now)=pmonth and year(now)=pyear then
                response.write( "<td align=center bgcolor=ffaaaa><a href='Search.asp?Field=GuestTime&KindID=0&keyword=" &pyear& "-" & pmonth & "-" & iv & "' target=_parent>" & iv & "</a></td>")
            else
                response.write( "<td align=center><a href='Search.asp?Field=GuestTime&KindID=0&keyword=" &pyear& "-" & pmonth & "-" & iv & "' target=_parent>" & iv & "</a></td>")
            end if
        else
            response.write( "<td> </td>")
        end if
 
   '如果能被7整除（每行顯示7個）則輸出一個換行
        if i mod 7=0 then
            response.write( "</tr><tr align=center bgcolor=ffffff height=19>")
        end if
        i=i+1
    loop
%>
</table> 
 

2、修改PowerEasy.GuestBook.asp文件

找到

                If IsDate(Trim(Request("keyword"))) = False Then
                    FoundErr = True
                    ErrMsg = ErrMsg & "<li>" & XmlText("Guest", "ShowAllGuest/Err1", "輸入的關鍵字不是有效日期！") & "</li>"
                    Exit Sub
                Else
                    If SystemDatabaseType = "SQL" Then
                        sqlGuest = sqlGuest & " and GuestDatetime = '" & Trim(Request("keyword")) & "' "
                      Else
                        sqlGuest = sqlGuest & " and GuestDatetime = #" & Trim(Request("keyword")) & "# "
                    End If
                End If
  -----------------------------------------------------------------------------------
 改為
                If IsDate(Trim(Request("keyword"))) = False Then
                    FoundErr = True
                    ErrMsg = ErrMsg & "<li>" & XmlText("Guest", "ShowAllGuest/Err1", "輸入的關鍵字不是有效日期！") & "</li>"
                    Exit Sub
                Else
                    If SystemDatabaseType = "SQL" Then
   '如果數據量不大，用datediff是可以的，否則影響性能就最好用>=和 <  
              ' sqlGuest = sqlGuest & " and GuestDatetime = '" & Trim(Request("keyword")) & "' "
              'sqlGuest = sqlGuest & " and  GuestDatetime between '" & Trim(Request("keyword")) & " 00:00:00'  and '" & Trim(Request("keyword")) & " 23:59:59' "
              sqlGuest = sqlGuest & " and datediff(day,guestdatetime,'" & Trim(Request("keyword")) & "')=0 "
                    Else    
              'sqlGuest = sqlGuest & " and GuestDatetime = #" & Trim(Request("keyword")) & "# "
              sqlGuest = sqlGuest & " and GuestDatetime between #" & Trim(Request("keyword")) & " 00:00:00#  and  #" & Trim(Request("keyword")) & " 23:59:59#  "
              'sqlGuest = sqlGuest & " and datediff(day,guestdatetime,'" & Trim(Request("keyword")) & "')=0 "
                    End If
                End If