Highscore list

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Highscore list

Logged in as: Guest

arrSession:exec spGetSession 2,2,544

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> Highscore list
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Highscore list - 12/29/2001 7:41:23 AM

starlord

Posts: 2
Score: 0
Joined: 12/29/2001
From:
Status: offline

Hi! I have a dice game, made in Java.(an applet). The game is inside an ASP-site. All the variables were sent, from the applet to a ASP-site called "Tarning_insert.asp", and from there to a Access database. A score is set after each game. I want to have that score sorted in a list, the highest score should have "place 1" and so on...but all data should be still sorted by date(datum)desc.

Some of my code on "tarnings_spel.asp"
<%

dbfile=Server.MapPath("Tarnings_Spel.mdb")
Set OBJdbConnection=Server.CreateObject("ADODB.Connection")
OBJdbConnection.Open "driver={Microsoft Access Driver (*.mdb)};dbq="&dbfile

Set rs = Server.CreateObject("ADODB.Recordset")
sql= "SELECT * FROM tarnings_spel order by datum desc"
rs.Open sql, OBJdbConnection, 3, 3

%>

<%
While Not rs.EOF
Response.Write("?~:: Spel nr " & rs.fields("id") & " ::~? " )
Response.Write("Datum: " & rs.fields("datum") & " " )
Response.Write("Namn: " & rs.fields("namn") & " ")
Response.Write("Omgangar: " & rs.fields("omgangar") & " ")
Response.Write("Score: " & rs.fields("score") & " ")

rs.movenext

Response.Write("<hr noshade>")
Wend

%>

Here is the applet.
http://web.domaindlx.com/lova/tarning/tarnings_spel.asp

Does anyone understand my problem..
Thankful for your help.
/S