How to show score into Html page

[aegisteam2]

Hi All,

I have created one HTML online quality tracker for my QA team once you select the option/fill the data and after click on the submit button the HTML page redirect that data into .asp page and then .asp page save the data into ms access database then thanks.html page shows and again quality html tracker shows for filling the fresh data . NOW what i need is once we/QA team fill the data into HTML page they can see see the total score of the agent/candidate is it possible?
If above thing is not possible. are we able to see the total score of the agent in ms access database? if yes then what coding i have to do in HTML/asp/access please help me with this. Just to let you know i am not a professional developer just having few knowledge html/asp/access. please give me the details in brief so that i can add all the coding into my page/database please feel free to contact me (removed)
sorry for the trouble

[jhardman]

There are several ways you could do this. Let me ask, how are you adding the new entry to the db currently? The way that makes the most sense to me is to run a second query to the db immediately after you add the record. Look for code in the asp page that 1- creates a connection to the db 2- opens the connection 3- sends an insert command. Could you show me the basic form or structure of that part of the code? Take out any passwords and security info of course.

Before I tell you how to pull that value, how is the value stored?

Jared

[aegisteam2]

here is the asp coding

<%

'Dimension variables
Dim adoCon 'Holds the Database Connection Object
Dim rsAddComments 'Holds the recordset for the new record to be added to the database
Dim strSQL 'Holds the SQL query for the database

'Create an ADO connection odject
Set adoCon = Server.CreateOb ject("ADODB.Con nection")

'Set an active connection to the Connection object using a DSN-less connection
adoCon.Open "DRIVER={Micros oft Access Driver (*.mdb)}; DBQ=" & Server.MapPath( "database\quali ty2.mdb")

'Set an active connection to the Connection object using DSN connection
'adoCon.Open "DSN=qualit y2"

'Create an ADO recordset object
Set rsAddComments = Server.CreateOb ject("ADODB.Rec ordset")

'Initialise the strSQL variable with an SQL statement to query the database
strSQL = "SELECT quality2.DOC, quality2.DOE, quality2.Adviso r, quality2.TL, quality2.Manger , quality2.Evalua tor, quality2.NiceId , quality2.Mobile , quality2.cust_n ame, quality2.call_t ype, quality2.query_ type, quality2.subcat egory, quality2.Q1, quality2.Q2, quality2.Q3, quality2.Q4, quality2.Q5, quality2.Q6, quality2.Q7, quality2.Q8, quality2.Q9, quality2.Q10, quality2.Q11, quality2.Q12, quality2.Q13, quality2.Develo pmentFocus, quality2.CallMo tivational FROM quality2;"
'Set the cursor type we are using so we can navigate through the recordset
rsAddComments.C ursorType = 2

'Set the lock type so that the record is locked by ADO when it is updated
rsAddComments.L ockType = 3

'Open the quality2 table using the SQL query held in the strSQL varaiable
rsAddComments.O pen strSQL, adoCon

'Tell the recordset we are adding a new record to it
rsAddComments.A ddNew

'Add a new record to the recordset


' Case Info
rsAddComments.F ields("DOC") = Request.Form("D OC")
rsAddComments.F ields("DOE") = Request.Form("D OE")
rsAddComments.F ields("Advisor" ) = Request.Form("A dvisor")
rsAddComments.F ields("TL") = Request.Form("T L")
rsAddComments.F ields("Manger") = Request.Form("M anger")
rsAddComments.F ields("Evaluato r") = Request.Form("E valuator")

' Query type
rsAddComments.F ields("NiceId") = Request.Form("N iceId")
rsAddComments.F ields("Mobile") = Request.Form("M obile")
rsAddComments.F ields("cust_nam e") = Request.Form("c ust_name")
rsAddComments.F ields("call_typ e") = Request.Form("c all_type")
rsAddComments.F ields("query_ty pe") = Request.Form("q uery_type")
rsAddComments.F ields("subcateg ory") = Request.Form("s ubcategory")


' Following the Process
rsAddComments.F ields("Q1") = Request.Form("Q 1")
rsAddComments.F ields("Q2") = Request.Form("Q 2")
rsAddComments.F ields("Q3") = Request.Form("Q 3")
rsAddComments.F ields("Q4") = Request.Form("Q 4")
rsAddComments.F ields("Q5") = Request.Form("Q 5")
rsAddComments.F ields("Q6") = Request.Form("Q 6")
rsAddComments.F ields("Q7") = Request.Form("Q 7")
rsAddComments.F ields("Q8") = Request.Form("Q 8")
rsAddComments.F ields("Q9") = Request.Form("Q 9")
rsAddComments.F ields("Q10") = Request.Form("Q 10")
rsAddComments.F ields("Q11") = Request.Form("Q 11")
rsAddComments.F ields("Q12") = Request.Form("Q 12")
rsAddComments.F ields("Q13") = Request.Form("Q 13")

' Overall Comments
rsAddComments.F ields("Developm entFocus") = Request.Form("D evelopmentFocus ")
rsAddComments.F ields("CallMoti vational") = Request.Form("C allMotivational ")




'Write the updated recordset to the database
rsAddComments.U pdate

'Reset server objects
rsAddComments.C lose
Set rsAddComments = Nothing
Set adoCon = Nothing


Response.Redire ct "Thanks_Quality 2.htm"
%>

[aegisteam2]

any update on this???

[ariful alam]

you are using 3 page
1. submit page
2. update/insert page
3. successful page

why not use 2 page with ajax support?

use a html page that submit data using ajax to a ashx page that update or insert data to database and send back required data through ajax to submit page. show the values from the ajax object.