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="JavaS cript1.1">
<!--
function sitestat(ns_l){ ns_l+="&ns__t=" +new Date().getTime( );ns_pixelUrl=n s_l;
if(document.ima ges){ns_1=new Image();ns_1.sr c=ns_l;}else
document.write( "<img src="+ns_l+" width=1 height=1>");}
sitestat("kenni stest");
//-->
</script><noscrip t>
<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<s up>*</sup> <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