|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
SQL Query not working HELP!! |
|
From: |
Digital_Biscuit |
|
Date: |
8/4/2003 4:17:53 PM |
|
IP: |
82.36.104.64 |
Got this SQL query and the idea is that it should pick up messages with the TimeofPost after the date in the string. But it aint. Can anyone help?? Oh and the access DB has the field set to datetime general date format.
Select Top 6 * from MESSAGES INNER JOIN USERS ON MESSAGES.UserID = USERS.UserID WHERE MESSAGES.RoomID = 1 AND MESSAGES.TimeofPost >= #04/08/2003 19:29:00# ORDER BY MessageID DESC
|
Follow Up - Re: SQL Query not working HELP!! - Bullschmidt 9/30/2003 7:40:24 PM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
