I am studying to learn ASP, and have started my journey with the book "Beginning Active Server Pages 3.0".

In chapter 15, page 689-690 is code-example called "BrowseListings.asp". When I try to run my application (in which "BrowseListings.asp" is just one of many pages) I end up with an error: Microsoft JET Database Engine (0x80040E07).
Trying to translate the error-message from Norwegian to English is states that "syntax error in date of query ExpirationDate > #07.08.2003# AND ItemStatus = 'Active'
/BegASPFiles/BrowseListings.asp, line 24".

Now I've checked that I have not misspelled or typed wrong any of the variables either in my .asp code-pages and in the "Classified.mdb" database. I've used the exact examples outlined in the book... But I can't get past this error.

Can anyone lend a helping hand?

Sincerly,
A. Grebstad.

Here's a listing of the actual code that returns the error:

...
<%
  Dim rsItems
  strSQL = "SELECT * FROM Item " & _
           "WHERE ExpirationDate > #" & FormatDateTime(Now,2) & "# " & _
           "AND ItemStatus = 'Active';"
  Set rsItems = Server.CreateObject("ADODB.Recordset")
  rsItems.Open strSQL, objConn
  If Not rsItems.EOF Then
...

Line 24, where the ExpirationDate is checked to be larger than FormatDateTime cause the error..

I am using an Access-database, in which the property ExpirationDate is in the same format as FormatDateTime(Now,2).

What could be wrong here ?


Arild