Save score into database

[cutzz]

Hi u all,

i've made a 10 paged asp quiz. at the end of the quiz u will recieve a score.
the script is shown below. my answer = how can i save this score into a database?

<!-- #include file="functions.asp" -->

<% function content %>


<%
session.timeOut = 45
call storeAnswers()
%>

<!-- Begin Sitestat4 code -->
<script language="JavaScript1.1">
<!--
function sitestat(ns_l){ns_l+="&ns__t="+new Date().getTime();ns_pixelUrl=ns_l;
if(document.images){ns_1=new Image();ns_1.src=ns_l;}else
document.write("<img src="+ns_l+" width=1 height=1>");}
sitestat("kennistest");
//-->
</script><noscript>
<img src="kennistest" width=1 height=1>
</noscript>
<!-- End Sitestat4 code -->


<span class="question" >Score</span>
<p>
<% select case calculateScore() %>
<% case 1,2,3,4,5 %>
Jammer, u heeft maar <% =calculateScore() %> vraag/vragen goed beantwoord.
<br /><br />
<b>Hou uw marktkennis op peil!</b>
<br /><br />
Neem nu een <a href="/aanmelden/inschrijven.asp" style="text-decoration:none;" ><strong>gratis</strong></a> bla bla bla
</p>
<% case else %>
Gefeliciteerd, u heeft <% =calculateScore() %> vragen goed beantwoord!
<br /><br />
<b>Wilt u uw marktkennis op peil houden? </b>
<br /><br />
Neem dan nu een <a href="/aanmelden/inschrijven.asp" style="text-decoration:none;" ><strong>gratis</strong></a> bla bla bla<% end select %>

<!--
U heeft <b class="score" ><% =(10-calculateScore()) * 10 %>%</b> van de vragen foutief beantwoord.
</p>
oude score
<p>
Uw marktkennis is te beoordelen met rapportcijfer^* <b class="score" ><% =calculateScore() %></b>.
</p>

Help me out if u can.

[jhardman]

Welcome to the scripts DN. Here is a useful tutorial that walks you thru the basic steps of connecting to and manipulating a database using ADO (a built-in active-X component).

Jared