|
|
|
|
|
| | |
| |
Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
