Save results to a database table using ASP

I am currently having problems using ASP to gather the results and enter them into a databse table. I understand that there is a PHP example but i'm afraid I am no good with ASP. Does anyone have any ASP examples please?

Thanks :)

It meant to say "I am no good with PHP" :)

Hi Nicky,

I don't have any ASP code samples, but here's some information that should help to get you started.

The quizzes use Flash's xml.sendandload() method to send the results as an XML document to the server.

There's a bit of discussion online regarding the best way to receive this XML in ASP. I found the following code suggestion through Google, but there are lots of others.

[forums.asp.net]

Flash expects to get back a trivial XML document . . . something like <OK/> works well. If you find the XML has becomed corrupted in transit or you want the Flash to send the XML again, send it back a 500 server error and it will attempt to resend the XML.

When testing, set the main server and the backup server both to the same URL, this will ensure that the quiz sends its results only to the script that you're developing.