Chap. 15, pages 689-690 : Help !
I am currently building the application outlined in the whole of chapter 15, but at line 24 in the file "BrowseListings.asp" I have stumbled upon an error that I do not understand.
Microsoft JET Database Engine (0x80040E07).
Syntax error in Date of query expression ExpirationDate > #07.08.2003# AND ItemStatus = 'Active'
/BegASPFiles/BrowseListings.asp, line 24".
(the errror message is roughly translated from Norwegian)
Here's a listing of the actual code that returns the error:
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
I've checked both my "Classified.mdb" Access-database and all other .asp code-pages involved for spelling errors but found none.
The error is in the strSQL - but *what* is wrong ?
Hope someone can help me.