|
 |
access_asp thread: Select Statement problem with dates
Message #1 by "Stephanie" <stephanieweigel@y...> on Sat, 20 Apr 2002 17:55:10
|
|
I am having a problem with the following code:
objrs1.Open "Select * from Events Where EventID = " & EventID & " AND
EventDate = #" & EventDate & "#" , objconn1, 3, 3, 1
Here is my error message:
Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
/final/Registration2.asp, line 10
Any ideas?
Thanks,
Steph
Message #2 by "Ken Schaefer" <ken@a...> on Mon, 22 Apr 2002 10:48:40 +1000
|
|
www.adopenstatic.com/faq/80040e07.asp
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Stephanie" <stephanieweigel@y...>
Subject: [access_asp] Select Statement problem with dates
: I am having a problem with the following code:
:
: objrs1.Open "Select * from Events Where EventID = " & EventID & " AND
: EventDate = #" & EventDate & "#" , objconn1, 3, 3, 1
:
: Here is my error message:
: Error Type:
: Microsoft JET Database Engine (0x80040E07)
: Data type mismatch in criteria expression.
: /final/Registration2.asp, line 10
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
|
|
View Cart
