Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-07-02 : 09:11:00
|
| Danie writes "Here is my ASP SQL Statement. Why Doesn't it work? What am I missing or doing wrong?strSQL = "Select * FROM WellClass WHERE ClassDate >= '" & DATE & "' ORDERBY ClassDate"Error:Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'ClassDate >= '6/23/2004' ORDERBY ClassDate'" |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2004-07-02 : 09:11:00
|
| It's ORDER BY. You need a space between order and by. |
 |
|
|
|
|
|
ASP SQL Statement to show only today's date or later then sort by date