ASP

Order by problem

6 views

Hi,

I have this query

SELECT TOP 3 Total FROM Results WHERE TestDate = '" & getpdate & "' order by Total desc"

when the results are displayed they are like this

Code:

UNC     Richard Moore  1890.23
UFL     Dixie Bush        90.23
UCL     Robert Max     1456.45
d

can someone tell me why the order is not working

because i want UCL above UFL as the points are higher

Any idea

charles

More ASP fixes

IIS: web.config redirect to another url preserving the original one in the address bar Get actual URL from address bar in Classic ASP on a 404 redirected page Requested operation requires a current record.asp guestbook w/ textfile guestbook enties - tutorials add asp.net pages to an asp classic website