ORDER BY SQL statement not working?

Question

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

hsueh001 · Accepted Answer

Try:
I'm assuming MS Access 2000 and not MS SQL Server 2000?

SELECT *
FROM [ProdServers]
ORDER BY [Server Name/OS/DNS Alias]

meenu · Answer

Order by clause should be separated by comma.
e.g., ORDER BY Server Name, OS, DNS Alias
try this let me know

Arbitrage · Answer

I'm not an expert by any means, but the order by looks fishy with the slashes.  I doubt that your column is named that.  Maybe you wanted to have a primary, secondary, and tertiary sort and they should be delimited by commas instead?

Anonymous · Answer

SELECT * FROM ProdServers ORDER BY [Server Name], [OS], [DNS Alias]

Nags · Answer

The ORDER BY has to have the name of the field and the sorting order ASCENDING or DESCENDING and use commas to seperate each field.

Eg. ORDER BY name ASC, regno DESC;

Jack · Answer

You have a space in "Server Name", it probably needs to be in brackets.

Trending News

ORDER BY SQL statement not working?

6 Answers