ASP Syntax error in date in query expression

[ Kekc @ 20.10.2005. 23:18 ] @

Molim Vas, ako neko ima rešenje za ovo greško:

Error Type:
Microsoft JET Database Engine (0x80040E07)
Syntax error in date in query expression 'calendarDate = #1.10.2005#'.
/Herberstein/calendar_02/calendar.asp, line 139

A koda je:

Code:
<%@ Language=VBScript %>
<%  Option Explicit %>
<%

' ---------- Author Information ----------
' Written By: Jon Akelaitis
' Copyright 2001 All Rights Reserved
' Web Page: http://www.phoenixs.info
' ICQ: 14664736
' Email: [email protected]
' This set of comments is not to be altered or removed

' ---------- Page Functions ----------
    Function FormatStr(String)
      ' Replaces a double carrige return with a paragraph break
      ' a single carrige return with a break rule and CHR(13) with nothing
      String = Replace(String, CHR(13), "")
      String = Replace(String, CHR(10) & CHR(10), "</P><P>")
      String = Replace(String, CHR(10), "<BR>")
      FormatStr = String
    End Function

' ---------- Page Variables ----------
    Const intCharToShow = 19        ' The number of characters shown in each day
    Const bolEditable   = True        ' If the calendar is editable or not (Can be tied into password verification)

    Dim dtToday             ' Today's Date
    Dim dtCurrentDate            ' The current date
    Dim aCalendarDays(42)        ' Array of possible calendar dates
    Dim iFirstDayOfMonth        ' The first day of the month
    Dim iDaysInMonth             ' The number of days in the month
    Dim iColumns, iRows    , iDay, iWeek    ' The numer of columns and rows in the table, and counters to print them
    Dim objConn, strConn, strSQL, objRS ' Database Variables
    Dim counter             ' Loop counter
    Dim strNextMonth, strPrevMonth    ' The next and previous month dates
    Dim dailyMsg            ' The message for the day
    Dim dtOnDay                ' The current day being displayed by the loops
    Dim strPage                ' The link that each day takes you too

' ---------- Variable Definitions ----------
    dtToday       = Date()

    If Request("currentDate") <> "" Then
      dtCurrentDate = Request("currentDate")
    Else
      dtCurrentDate = dtToday
    End If

    iFirstDayOfMonth = DatePart("w", DateSerial(Year(dtCurrentDate), Month(dtCurrentDate), 1))
    iDaysInMonth = DatePart("d", DateSerial(Year(dtCurrentDate), Month(dtCurrentDate)+1, 1-1))

    For counter = 1 to iDaysInMonth
      aCalendarDays(counter + iFirstDayOfMonth - 1) = counter
    Next

    iColumns = 7
    iRows    = 6 - Int((42 - (iFirstDayOfMonth + iDaysInMonth)) / 7)

    strPrevMonth = Server.URLEncode(DateAdd("m", -1, dtCurrentDate))
    strNextMonth = Server.URLEncode(DateAdd("m",  1, dtCurrentDate))

' ---------- Drawing the Calendar ----------
%>

<HTML>
<HEAD>
  <TITLE>Caledar - <%= MonthName(Month(dtCurrentDate)) & " " & Year(dtCurrentDate) %></TITLE>
  <STYLE TYPE="text/css">
    
  </STYLE>
</HEAD>
<BODY>
  <FORM NAME="pageForm" ACTION="calendar.asp" METHOD="GET">
  <CENTER>
  <TABLE CELLPADDING=0 CELLSPACING=0 WIDTH=600 BORDER=0>
    <TR>
      <TD CLASS="blackBacking">
    <TABLE CELLSPACING=1 CELLPADDING=1 BORDER=0 WIDTH=600>
        <TR HEIGHT=30px>
          <TD CLASS="names" HEIGHT=30px COLSPAN=7>
          <A HREF="calendar.asp?currentDate=<%= strPrevMonth %>">« Prev</A>
           
          <SELECT NAME="currentDate" CLASS="calFormMenu" onChange="pageForm.submit()">
          <% For counter = 1 to 12 %>
            <OPTION VALUE="<%= DateSerial(Year(dtCurrentDate), counter, 1) %>" <% If (DatePart("m", dtCurrentDate) = counter) Then Response.Write "SELECTED"%>><%= MonthName(counter) & " " & Year(dtCurrentDate) %></OPTION>
          <% Next %>
          </SELECT>
           
          <A HREF="calendar.asp?currentDate=<%= strNextMonth %>">Next »</A>
            </TD>
          </TR>
      
          <TR VALIGN="TOP" ALIGN="CENTER">
            <% For iDay = vbSunday To vbSaturday %>
            <TD WIDTH="14%" class="names"><%= WeekDayName(iDay, True) %>.</TD>
            <% Next %>
          </TR>
<%
    Set objConn = Server.CreateObject("ADODB.Connection")
    strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & Server.MapPath("db.mdb") & ";Persist Security Info=False;"
    objConn.Open(strConn)

    For iWeek = 1 To iRows
      Response.Write "<TR VALIGN=TOP>"
      For iDay = 1 To iColumns
    ' Checks to see if there is a day this month on the date being written
    If aCalendarDays((iWeek-1)*7 + iDay) > 0 then
      dtOnDay = DateSerial(Year(dtCurrentDate), Month(dtCurrentDate), aCalendarDays((iWeek-1)*7 + iDay))

      ' Checks to see if the day being printed is today
      If dtOnDay = dtToday Then
        Response.Write "<TD HEIGHT=55 CLASS='calCurrentDay'>"
       Else
           Response.Write "<TD HEIGHT=55 CLASS='calOtherDay'>"
       End If

      ' Checks to see the type of calendar (editable or non-editable)
       If (bolEditable) then
           strPage = "updateCalendar_form.asp?currentDate=" & dtOnDay
       Else
           strPage = "viewDay.asp?currentDate=" & dtOnDay
      End If

      ' Checks for a message on the day being written
      strSQL = "SELECT * FROM calendar WHERE calendarDate = #" & dtOnDay & "#"
      Set objRS = objConn.Execute(strSQL)
      If NOT objRS.EOF Then
        dailyMsg = objRS("calendarText")
      Else
        dailyMsg = ""
      End If
      Set objRS = Nothing

      ' Checks to see if the message is too long to be displayed in the mini date box
          If (Trim(dailyMsg) = Trim(Left(dailyMsg, intCharToShow))) Then
      Else
         dailyMsg = Trim(Left(dailyMsg, intCharToShow-4)) & " ..."
          End If

       Response.Write ("<A HREF=""" & strPage & """> " & aCalendarDays((iWeek-1)*7 + iDay) & "<BR>  " & FormatStr(dailyMsg) & "</A>")
    Else
      Response.Write ("<TD HEIGHT=50 CLASS='calNotDay'> ")
    End IF

    Response.Write "</TD>"
      Next
      Response.Write "</TR>"
    Next

    objConn.Close
    set objConn = Nothing
%>

    </TABLE>
      </TD>
    </TR>
  </TABLE>
<%
    ' Notification for the user to know that the calendar is editable
    If (bolEditable) Then Response.Write "EDITABLE CALENDAR<BR>"
%>
  </FORM>

  
  <FONT COLOR="#000000" FACE="Verdana" SIZE="1">
  Copyright © 2001. All Rights Reserved.<BR>
  Written By: <A HREF="mailto:[email protected]">Jon Akelaitis</A>
  </FONT>
  

  </CENTER>
</BODY>
</HTML>

Kolko se meni čini, problem je u formatu datuma, koda je napravljena za engleski format, a ja imam slovenski. Več sam stavio LCID, a ne pomaže.

_{Shadowed: dodati [code] tagovi]}

_{[Ovu poruku je menjao Shadowed dana 21.10.2005. u 09:41 GMT+1]}