HotPotatoes - Storing Results in a Database 

You need the following files:


1. an Access Database: hotpot.mdb
2. a connection to the database: hotpot.asp
2. a file confirming that your results have been stored: results.asp
3. a file to close the results window: ok_i.html

> to download the files mentioned above, click here >
 

Settings: 

1st - Configure Outputs in HotPotatoes
- select CGI in"Outputs"
- under URL write the name of the file: results.asp
- insert your email and the instructions to your students

configure outputs window
 
 

2nd - Change the path to the database in the file "hotpot.asp"

- open the file "hotpot.asp" with a text editor like Notepad or NoteTab Light and replace the path to your database on your server.

configure connections

 

3rd - change some data in the file results.asp
 
- replace "mail.prof2000.pt" by the SMTP of your server;
- replace "prof2000@mail.prof2000.pt" by a valid email used by your server administration, which will be the sender of the scores to your own email;
- the mailer used in this case is DundasMailer, installed on the server where you have your files stored.
It is free and can be downloaded from: http://aspalliance.com/dundas/default.aspx

configure smtp server
 

4th - Upload your files

- send the mentioned files to your server, together with your HotPotatoes exercises.

You can use this as a test:

http://users.prof2000.pt/mfr/class10f_0405/match_inventions.html

And you can see the results here:

http://users.prof2000.pt/mfr/class10f_0405/resultados_bd.asp

Actions executed by the *.asp files: - they store the following results in the database:

- student's name, exercise name, score, exercise date and start time, exercise date and end time.
- email notification to the author of the exercise containing the student's name, score and end time.


original Portuguese file by Fernando Lacerda
adapted and translated by Fernanda Rodrigues


 
página alojada no Programa Prof2000