|
|
|
|
|
| | |
| |
Active Server Pages what is asp programming how to sample asp example code scripts software asp forum mail sessions applications global.asa CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
SQL Query not working HELP!! |
|
From: |
Digital_Biscuit |
|
Date: |
8/4/2003 2:30:27 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
