Interview Question in Sql Server 2000
Interview Question :: ORDER BY SQL statement not working |
I'm am using this SQL statement on my .asp (classic) page to order records by their server name:
SELECT *
FROM ProdServers
ORDER BY Server Name / OS / DNS Alias
But it is returning these two errors:
When I click test (ultradev):
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Server Name / DNS Alias'
When I try and test it on the server I get this error
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Server Name / OS / DNS Alias'.
/SORTTESTprod_servers.asp, line 10
It doesn't make any sense that it wants line 10 because:
ecordset1.Open() ??
What are your thoughts?
Oh, I'm using a Microsoft 2000 Database, and the primary key column is ID |
|
|
|
Loading ...