Flasher Archive

[Previous] [Next] - [Index] [Thread Index] - [Previous in Thread] [Next in Thread]


Subject: RE: [flasher] Top 10 Highscores With ASP
From: Scott Jeppesen
Date: Tue, 13 Feb 2001 16:52:11 -0000

Actually I just finished one...but the file is at work. It's fairly simple
though so I'll just code from the top of my head here, there may be typos:
<HTML>
<HEAD>
</HEAD>
<BODY>
<TABLE>
<TR><TD>Name</TD><TD>Score</TD></TR>
<%
Dim db,List
' Make the database connection
Set db = Server.CreateObject("ADODB.Connection")
db.open YourConnectionStringGoesHere
' Pull all of the records from the database and order then by the Score
field, in this case descending order.
Set List = db.execute("SELECT FirstName, LastName, Score FROM SCORES ORDER
BY Score desc")
x=0
While x<10
%>
<TR><TD><%= List(0) %> <%= List(1) %></TD><TD><%= List(2) %></TD></TR>
<%
x=x+1
List.movenext
Wend
%>
</TABLE>
</BODY>
</HTML>

Hope that helps some.

SJ

-----Original Message-----
From: Paul Steven [p [dot] stevenatbtinternet [dot] com (mailto:p [dot] stevenatbtinternet [dot] com)]
Sent: Tuesday, February 13, 2001 4:23 AM
To: flasher from chinwag
Subject: [flasher] Top 10 Highscores With ASP


Hi there

I have been asked to add a top ten high scores functionality to a game I
made in Flash.

Unfortuantely, the server does not have Perl or PHP and the only method
available to me is ASP using an SQL 7 database. Normally I have done this in
the past using a cgi script and a text file so I am a bit out of my depth
with ASP and databases.

Are there any tutorials or good resources on this out there? Or has anyone
got an example movie.

Thanks in advance

Paul



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The Chinwag site carries a wealth of Flash resources.
Find useful links, suggested reading and archives at:

** http://www.chinwag.com/flasher **
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
You are subscribed to flasher as: ScottJategoxstudios [dot] com
To unsubscribe, email leave-flasher-479780Vatlists [dot] chinwag [dot] com



[Previous] [Next] - [Index] [Thread Index] - [Next in Thread] [Previous in Thread]