Game contests

I was going to suggest a pivot table but didn't want to get my nose in where it didn't belong. I'll fill free to make suggestions anyway :) I have this bloated opinion that I'm quite the spreadsheet jockey myself.

Actually, I was thinking you could write a simple little VB program with excel .txt file as a data source and have it calculate the winners for ya, with the press of a button, but that would be getting a little out of hand. Making a mountain out of a mole hill.

 
***SNIP***
Actually, I was thinking you could write a simple little VB program with excel .txt file as a data source and have it calculate the winners for ya, with the press of a button, but that would be getting a little out of hand. Making a mountain out of a mole hill.
Click to expand...
I GOT IT!!!!

First, install the ASP "driver" for UNIX - ChilliASP, I believe it's called. Then, create a database to store all the predictions, along with username and date of submission. Then, create an ASP web page with form fields for everyone to enter their predictions.

Finally, using ASP or VB, pull the data based on the applicable criteria and have it displayed as a "real time" data pull! Brilliant!

And here's the best part...Chad has over a week to get it done!

 
You could actually add in some logic to compile past scores and calculate the probability of each persons predictions being correct, maybe we could even try to build in some sort of artificial intelligence. Eventually we could eliminate the necessity for people to post their guesses altogether, just have the program make the predictions for the members. Brilliant!

 
Uhhhh.... what?  :blink:
Click to expand...
What, don't you wish you had a dawson's creek trapper keeper? If I did it would be awesome-o!
Click to expand...
Yes, yes it would.

I thought about that slacker. It would be pretty easy to do. The only manual part at this point is entering the data from the predicitions. If we had a custom PHP or ASP web app that did it that would rule.

 
Uhhhh.... what?  :blink:
Click to expand...
What, don't you wish you had a dawson's creek trapper keeper? If I did it would be awesome-o!
Click to expand...
Yes, yes it would.

I thought about that slacker. It would be pretty easy to do. The only manual part at this point is entering the data from the predicitions. If we had a custom PHP or ASP web app that did it that would rule.
Click to expand...
Tell you what, I'll get it started on the ASP code. We can call this one "connection.asp". Just do an INCLUDE statement for all other files...

Response.Buffer = true

 

dim strDBType, strConnString, strTablePrefix, strMemberTablePrefix, strFilterTablePrefix

Dim counter, ConnErrorNumber, ConnErrorDesc, blnSetup

 

strDBType = "access"

 

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\servername\subfoldername\dbfoldername\dbname.mdb"

 

on error resume next

 

blnLoadConfig = TRUE

 

set my_Conn = Server.CreateObject("ADODB.Connection")

my_Conn.Errors.Clear

Err.Clear

 

my_Conn.Open strConnString

for counter = 0 to my_conn.Errors.Count -1

ConnErrorNumber = Err.Number

ConnErrorDesc = my_Conn.Errors(counter).Description

If ConnErrorNumber <> 0 Then

If blnSetup <> "Y" Then

my_Conn.Errors.Clear

Err.Clear

Response.Redirect "setup.asp?RC=1&CC=1&strDBType=" & strDBType & "&EC=" & ConnErrorNumber & "&ED=" & Server.URLEncode(ConnErrorDesc)

else

blnLoadConfig = FALSE

end if

end if

next

 

my_Conn.Errors.Clear

Err.Clear

That'll get the connection set. 'Course, you need to change the path information and dbname to the actual path and name once you create and install them.

Now, we need a file to close the connection, which we will INCLUDE at the end of each ASP file. So, here's one well call "close.asp"

my_Conn.Close

set my_Conn = nothing

%>

Okay, take it away, Chad. All you need now are the files to create the form page with submission, the output page, the javascript INCLUDES and the database created. Oh, and declare all the variables, but that'll depend of the the DB field names, to some extent. Easy!

 
Back
Top