A
Anonymous
Guest
Basically, i've got a quiz with a log on system, using an MS Access database on a DSN reserved for me.
Now the database has a table for those registered and a quiz table.
The quiz table holds the username of the person taking the quiz and which questions the person got wrong or right, with 1 being correct and 0 being wrong. I have also a results field that i would like somehow to add up the marks.
Now the problem is how do i get the system to add the username to the quiz table with the marks they scored. I'm guessing its something to do with the cfapplication tag.
How do i add up the marks in that table.
Whats the SQL command to show the current users results in the table.
Theres some beer money involved if anyone can help.
If your having trouble understanding i can forward my work if you have your own home Dreamweaver and Coldfusion Server.
Joske
Now the database has a table for those registered and a quiz table.
The quiz table holds the username of the person taking the quiz and which questions the person got wrong or right, with 1 being correct and 0 being wrong. I have also a results field that i would like somehow to add up the marks.
Now the problem is how do i get the system to add the username to the quiz table with the marks they scored. I'm guessing its something to do with the cfapplication tag.
How do i add up the marks in that table.
Whats the SQL command to show the current users results in the table.
Theres some beer money involved if anyone can help.
If your having trouble understanding i can forward my work if you have your own home Dreamweaver and Coldfusion Server.
Joske