|
|
|
|
|
| | |
| |
PowerASP active server pages asp.net microsoft .net framework sdk learn asp what is asp tutorial learn asp.net 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
