|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
