raymondbell@hotmail.com
|
| Posted: 10/14/2002, 6:06 AM |
|
Why am i getting this problem with ASP SQL query??
Error: Data type mismatch in criteria expression. (Microsoft JET Database Engine)
SELECT * FROM calendar WHERE event_date >= '01/01/2001' and event_date <= '29/12/2001' ORDER BY event_date
|
|
|
 |
info@djborg.com
|
| Posted: 10/14/2002, 12:21 PM |
|
The SELECT statement you used is treating the dates wrong (if the fields are date fields in Access)
You had:
SELECT * FROM calendar WHERE event_date >= '01/01/2001' and event_date <= '29/12/2001' ORDER BY event_date
Try:
SELECT * FROM calendar WHERE event_date >= #01/01/2001# and event_date <= #29/12/2001# ORDER BY event_date
I hope this helps...
|
|
|
|
Ray Bell
|
| Posted: 10/15/2002, 3:20 AM |
|
Cheers DJ Borg.
I had to change the source typr to sql instead of table which i was using..cheers again
|
|
|
|
|
