No value given for one or more required parameters. (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

gantan -> No value given for one or more required parameters. (9/24/2007 23:23:52)


Hi, please check for me the coding?
Really not have idea, it keep on showing this error: 
Microsoft JET Database Engine error '80040e10' 

No value given for one or more required parameters. 

/onlineSurvey/survey/trainingQ.asp, line 479

This is my website's link :
http://msd-onboarding.supplychain.agilent.com/onlineSurvey/survey/trainingQ.asp

I just set for the 1st question. The others radio button not have function yet.
Please rate for the first question only, then click for "Submit" button.. The error will pop out.

I will appreciate if somebody point out my mistake..
Thank..



ou812 -> RE: No value given for one or more required parameters. (9/25/2007 0:17:06)

Without seeing your code it is hard to say exactly what it could be but it is more than likely one of these - miss spelled column name, not enough parameters to match columns, or incorrect delimiters around a value. Here's a page with some nice examples:
http://www.adopenstatic.com/faq/80040e10.asp#scenario3




gantan -> RE: No value given for one or more required parameters. (9/25/2007 1:21:40)

Sorry... Forget to post my coding. 

<% 
Dim ConnectString
Dim rsSurvey
Dim sql
Dim objConn
Dim R1_1, R2_1, R3_1, R4_1, RNA_1

R1_1=request.form("q1")
R2_1=request.form("q1")
R3_1=request.form("q1")
R4_1=request.form("q1")
RNA_1=request.form("q1")

'open database 
ConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("\onlineSurvey\survey\logIn\survey.mdb") & ";Persist Security Info=False" 
Set objConn = Server.CreateObject("ADODB.Connection") 
objConn.open ConnectString 

sql = "UPDATE AnswerTraining SET R1= "&R1_1&" +1, R2= "&R2_1&" +1, R3= "&R3_1&" +1, R4= "&R4_1&" +1, RNA= "&RNA_1&" +1 WHERE QUESTION_NO=1"
objConn.execute sql

objConn.Close 
Set ObjConn=Nothing 

%>



rdouglass -> RE: No value given for one or more required parameters. (9/25/2007 8:25:39)

quote:

sql = "UPDATE AnswerTraining SET R1= "&R1_1&" +1, R2= "&R2_1&" +1, R3= "&R3_1&" +1, R4= "&R4_1&" +1, RNA= "&RNA_1&" +1 WHERE QUESTION_NO=1"


Have you tried it this way yet?

sql = "UPDATE AnswerTraining SET R1= "&R1_1 +1&", R2= "&R2_1 +1&", R3= "&R3_1 +1&", R4= "&R4_1 +1&", RNA= "&RNA_1 +1&" WHERE QUESTION_NO=1"

See what I did? I'm just adding the values in ASP instead of having the SQL engine add it so after parsing, I'm passing something like this:

UPDATE AnswerTraining SET R1= 3, R2= 7,...

instead of:

UPDATE AnswerTraining SET R1= 2+1, R2= 6+1,..

Does that make sense?

This is assuming all fields are numeric.



gantan -> RE: No value given for one or more required parameters. (9/25/2007 21:25:04)

Thank for giving me an opinion. I try it out, but get the error. 

Microsoft VBScript runtime error '800a000d' 

Type mismatch: '[string: "R2_1"]' 

/onlineSurvey/survey/trainingQ.asp, line 475


line 475 is:
strSQL = "UPDATE AnswerTraining" _
& "SET R1= "&R1_1+1&", R2= "&R2_1+1&", R3= "&R3_1+1&", R4= "&R4_1+1&", RNA= "&RNA_1+1&"" _
& "WHERE QUESTION_NO=1;"



gantan -> RE: No value given for one or more required parameters. (9/26/2007 3:41:22)

Actually the R1_1, R2_1, R3_1, R4_1, RNA_1 are radio button.
I just declare it as 
R1_1=request.form("q1")
R2_1=request.form("q1")
R3_1=request.form("q1")
R4_1=request.form("q1")
RNA_1=request.form("q1")


the "q1" is Group Name. Seem like got some problem for this declaration, right?? Can you please show me how to declare the radio button?



William Lee -> RE: No value given for one or more required parameters. (9/26/2007 4:01:18)


quote:

ORIGINAL: gantan

Actually the R1_1, R2_1, R3_1, R4_1, RNA_1 are radio button.
I just declare it as 
R1_1=request.form("q1")
R2_1=request.form("q1")
R3_1=request.form("q1")
R4_1=request.form("q1")
RNA_1=request.form("q1")


the "q1" is Group Name. Seem like got some problem for this declaration, right?? Can you please show me how to declare the radio button?


If R1_1, R2_1 etc are names of the Radio buttons in the submitting form, then on the asp page that they are posted to, the code should be something like this:

R1_1= request.form("R1_1")
R2_1=request.form("R2_1")
...and so on.

May I ask what is "ql" that you are passing ?



gantan -> RE: No value given for one or more required parameters. (9/26/2007 4:07:01)

"q1" is a name of the radio button.
so
quote:

R1_1=request.form("q1")
R2_1=request.form("q1")
R3_1=request.form("q1")
R4_1=request.form("q1")
RNA_1=request.form("q1")

"R1_1...." is a value of the radio button.
So the declaration is correct, right??



William Lee -> RE: No value given for one or more required parameters. (9/26/2007 4:41:13)

wait a minute..

when working with radio buttons, only one VALUE will be assigned to the NAME and send to the response page

You have 5 radio buttons in a group, user selecting any one will automatically deselect the rest, why you need to pass so many.

This aside, can you roughly explain what you are attempting to do with the SQL statement, esp with the "+1" inside the sql



gantan -> RE: No value given for one or more required parameters. (9/26/2007 4:53:37)

Thank for reply me.
I am doing the online survey.
I have 5 radio button in a group for the respondent to rating. Yup, user selecting any one will automatically deselect the rest.

quote:

sql = "UPDATE AnswerTraining SET R1= "&R1_1&" +1, R2= "&R2_1&" +1, R3= "&R3_1&" +1, R4= "&R4_1&" +1, RNA= "&RNA_1&" +1 WHERE QUESTION_NO=1"
objConn.execute sql


This sql mean that, when the respondent click for any one of the radio button, it will add 1 into the column. Do you get what i mean??

It is got others way to doing? I develop this project for almost 1 n half month, but still cannot store the survey result into the database.... fell very sad and resentful..
Hope that you will help me... Actually once I can store the survey result into the database, I think not have problem for me to show the chart, right? Coz the FP have build int Web Component to show the chart.
Thank a lot..



William Lee -> RE: No value given for one or more required parameters. (9/26/2007 4:59:53)

hey don't worry or disheartened, you've come to the right place.

I am not a super ASP guy but I do know some, so maybe I will take longer time. I try to understand what you are trying to do and when you explained, then the rest can see clearer and solve your problem when their side of the world wakes up.




gantan -> RE: No value given for one or more required parameters. (9/26/2007 5:18:06)

oh.... Thank.. thank so much.. William
I will paste my code here, hope somebody will come and help me.. 
<%@ Language = "VBScript" %>
<% OPTION EXPLICIT
Response.Buffer = True
 %>
<!--#include file="header.asp"-->

<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Survey1</title>
</head>

<body>
<% if len(request.form("Submit"))<=0 then %>

<p>
<b><font face="Bodoni Black" size="6"><span style="background-color: #99CCFF"> <marquee behavior="slide" width="582">Training Survey</marquee></span></font></b></p>
<form method="POST" action="--WEBBOT-SELF--">
	
  <table border="0" cellpadding="0" cellspacing="0" width="100%" height="279">
    <tr>
      <td width="100%" height="1">

<table border="0" cellpadding="0" cellspacing="0" width="799" height="991" id="table45">
	<!-- MSTableType="layout" -->
	<tr>
		<td valign="top" height="62" colspan="2">
		<!-- MSCellType="ContentHead2" -->
		<p style="margin-top: 0; margin-bottom: 0">
<font size="1" face="Verdana">Please make 
		sure to fill in ALL information below:</font></p>
		<p style="margin-top: 0; margin-bottom: 0">
		<font size="1" face="Verdana">This 
		Evaluation is completely confidential, please feel free to answer 
		honestly.</font></p>
		<p style="line-height: 0"> </td>
	</tr>
	<tr>
		<td></td>
		<td height="4"></td>
	</tr>
	<tr>
		<td valign="top" width="794">
		<!-- MSCellType="ContentBody" -->
		<p align="left" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="left" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="left" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="left" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<table border="0" width="100%" id="table46" cellspacing="0" cellpadding="0">
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">Course Name :</font></td>
				<td><font size="1" face="Verdana"><span style="font-size: 9pt">
				<input type="text" name="txtCourseName" size="29"></span></font></td>
			</tr>
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">Course Date :</font></td>
				<td><font size="1" face="Verdana"><span style="font-size: 9pt">
				<input type="text" name="txtCourseDate" size="29"></span></font></td>
			</tr>
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">Name :</font></td>
				<td><font size="1" face="Verdana"><span style="font-size: 9pt">
				<input type="text" name="txtName" size="29"></span></font></td>
			</tr>
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">Trainer :</font></td>
				<td><font size="1" face="Verdana"><span style="font-size: 9pt">
				<input type="text" name="txtTrainer" size="29"></span></font></td>
			</tr>
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">Market Segment :</font></td>
				<td>
				<p style="margin-bottom: -20px"><font size="1" face="Verdana">
				<span style="font-size: 9pt">
				<input type="radio" value="V5" name="b1"></span></font><font face="Verdana" style="font-size: 9pt">  EMT</font></p>
				<p style="margin-bottom: -20px"><font size="1" face="Verdana">
				<span style="font-size: 9pt">
				<input type="radio" value="V6" name="b1"></span></font><font face="Verdana" style="font-size: 9pt">  Automotive</font></p><p style="margin-bottom: -20px">
				<font size="1" face="Verdana"><span style="font-size: 9pt">
				<input type="radio" value="V7" name="b1"></span></font><font face="Verdana" style="font-size: 9pt">  Wireless</font><p style="margin-bottom: -20px"> </td>
			</tr>
		</table>
		<p align="left" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="left" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		___________________________________________________________________________________</p>
		<p align="left" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="left" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="left" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="left" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="left" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="left" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="center" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="center" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="center" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="center" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="center" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="left" style="line-height: 1px; margin-top: 10px; margin-bottom: 0">
		<font face="Verdana" size="1">Please click your response to the items. 
		Rate aspects of the course on a 1 to 4 scale 1 equals "strongly 
		disagree" </font></p>
		<p align="left" style="line-height: 1px; margin-top: 10px; margin-bottom: 0">
		<font face="Verdana" size="1">and 4 "strongly agree." Choose N/A if the 
		item is not applicable to this course. Your feedback is sincerely 
		appreciated</font></p>
		<p align="left" style="line-height: 1px; margin-top: 10px; margin-bottom: 0">
		<font face="Verdana" size="1">Thank you. </font></p>
		<p align="left" style="line-height: 1px"><b>
		<font face="Verdana" size="1">1= Strongly disagree, 2= Disagree, 3= 
		Agree, 4= Strongly agree, NA= Not applicable</font></b></p>
		<p align="center" style="line-height: 1px"><b>
		<font face="Tahoma" size="1"> </font></b></p>
		<table border="0" width="100%" id="table47" cellspacing="0" cellpadding="0">
			<tr>
				<td><b><font face="Verdana" style="font-size: 9pt">Quality of Logistics</font></b></td>
				<td width="20"><b><font face="Verdana" size="1">  1</font></b></td>
				<td width="21"><b><font face="Verdana" size="1"> 2</font></b></td>
				<td width="20"><b><font face="Verdana" size="1"> 3   </font>
				</b></td>
				<td width="22"><b><font face="Verdana" size="1"> 4  
				</font></b></td>
				<td width="213"><b><font face="Verdana" size="1"> NA                       </font>
				</b></td>
			</tr>
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">1. Logistical registration 
				process was effective</font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="R1_1" name="q1"></font></span></font></td>
				<td width="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="R2_1" name="q1"></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="Q3_1" name="q1"></font></span></font></td>
				<td width="22"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="R4_1" name="q1"></font></span></font></td>
				<td width="213"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="RNA_1" name="q1"></font></span></font></td>
			</tr>
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">2. Training Material was 
				accessible before the course began</font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V11" name="q2" checked></font></span></font></td>
				<td width="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V12" name="q2"></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V13" name="q2"></font></span></font></td>
				<td width="22"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V14" name="q2"></font></span></font></td>
				<td width="213"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V15" name="q2"></font></span></font></td>
			</tr>
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">3. Classroom facilities were 
				satisfactory</font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V11" name="q3" checked></font></span></font></td>
				<td width="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V12" name="q3"></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V13" name="q3"></font></span></font></td>
				<td width="22"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V14" name="q3"></font></span></font></td>
				<td width="213"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V15" name="q3"></font></span></font></td>
			</tr>
		</table>
		<p align="justify" style="line-height: 1px; margin-top:6px; margin-bottom:2px"> </p>
		<p align="justify" style="line-height: 1px; margin-top:6px; margin-bottom:2px"> </p>
		<p align="justify" style="line-height: 1px; margin-top:6px; margin-bottom:2px"> </p>
		<table border="0" width="100%" id="table48" cellspacing="0" cellpadding="0">
			<tr>
				<td><font face="Verdana" style="font-size: 9pt"><b>Course Content  </b>                                                         
				</font></td>
			</tr>
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">4. The course was useful</font></td>
				<td width="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V7" name="q4" checked></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V8" name="q4"></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V9" name="q4"></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V10" name="q4"></font></span></font></td>
				<td width="214"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V11" name="q4"></font></span></font></td>
			</tr>
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">5. The objective were clear</font></td>
				<td width="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V7" name="q5" checked></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V8" name="q5"></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V9" name="q5"></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V10" name="q5"></font></span></font></td>
				<td width="214"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V11" name="q5"></font></span></font></td>
			</tr>
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">6. The length was appropriate</font></td>
				<td width="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V7" name="q6" checked></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V8" name="q6"></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V9" name="q6"></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V10" name="q6"></font></span></font></td>
				<td width="214"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V11" name="q6"></font></span></font></td>
			</tr>
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">7. The level of the test was 
				acceptable</font></td>
				<td width="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V7" name="q7" checked></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V8" name="q7"></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V9" name="q7"></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V10" name="q7"></font></span></font></td>
				<td width="214"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V11" name="q7"></font></span></font></td>
			</tr>
		</table>
		<p style="margin-bottom: -10px"> </p>
		<table border="0" width="100%" id="table49" cellspacing="0" cellpadding="0">
			<tr>
				<td width="500"><font face="Verdana" style="font-size: 9pt"><b>About the Trainer</b>              
				</font></td>
			</tr>
			<tr>
				<td width="500"><font face="Verdana" style="font-size: 9pt">8. The trainer explained in a 
				clear way</font></td>
				<td bgcolor="#FFFFFF"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V7" name="q8" checked></font></span></font></td>
				<td bgcolor="#FFFFFF" width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V8" name="q8"></font></span></font></td>
				<td bgcolor="#FFFFFF" width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V9" name="q8"></font></span></font></td>
				<td bgcolor="#FFFFFF" width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V10" name="q8"></font></span></font></td>
				<td bgcolor="#FFFFFF" width="214"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V11" name="q8"></font></span></font></td>
			</tr>
			<tr>
				<td width="500"><font face="Verdana" style="font-size: 9pt">9. The trainer covered the 
				topics in course description </font></td>
				<td bgcolor="#FFFFFF"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V7" name="q9" checked></font></span></font></td>
				<td bgcolor="#FFFFFF" width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V8" name="q9"></font></span></font></td>
				<td bgcolor="#FFFFFF" width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V9" name="q9"></font></span></font></td>
				<td bgcolor="#FFFFFF" width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V10" name="q9"></font></span></font></td>
				<td bgcolor="#FFFFFF" width="214"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V11" name="q9"></font></span></font></td>
			</tr>
			<tr>
				<td width="500"><font face="Verdana" style="font-size: 9pt">10. The trainer made the 
				session dynamic and interactive</font></td>
				<td bgcolor="#FFFFFF"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V7" name="q10" checked></font></span></font></td>
				<td bgcolor="#FFFFFF" width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V8" name="q10"></font></span></font></td>
				<td bgcolor="#FFFFFF" width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V9" name="q10"></font></span></font></td>
				<td bgcolor="#FFFFFF" width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V10" name="q10"></font></span></font></td>
				<td bgcolor="#FFFFFF" width="214"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V11" name="q10"></font></span></font></td>
			</tr>
			<tr>
				<td width="500"><font face="Verdana" style="font-size: 9pt">11. The trainer demonstrated 
				in-depth knowledge about the topic</font></td>
				<td bgcolor="#FFFFFF"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V7" name="q11" checked></font></span></font></td>
				<td bgcolor="#FFFFFF" width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V8" name="q11"></font></span></font></td>
				<td bgcolor="#FFFFFF" width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V9" name="q11"></font></span></font></td>
				<td bgcolor="#FFFFFF" width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V10" name="q11"></font></span></font></td>
				<td bgcolor="#FFFFFF" width="214"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V11" name="q11"></font></span></font></td>
			</tr>
		</table>
		<p style="margin-bottom: -10px"> </p>
		<table border="0" width="100%" id="table50" cellspacing="0" cellpadding="0">
			<tr>
				<td><font face="Verdana" style="font-size: 9pt"><b>Impact on Performance</b>                                                 
				</font></td>
			</tr>
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">12. The course has given to me 
				a broader knowledge</font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V7" name="q12" checked></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V8" name="q12"></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V9" name="q12"></font></span></font></td>
				<td width="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V10" name="q12"></font></span></font></td>
				<td width="213"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V11" name="q12"></font></span></font></td>
			</tr>
			<tr>
				<td height="21"><font face="Verdana" style="font-size: 9pt">13. The course helps to 
				correct my weaknesses </font></td>
				<td width="20" height="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V7" name="q13" checked></font></span></font></td>
				<td width="20" height="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V8" name="q13"></font></span></font></td>
				<td width="20" height="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V9" name="q13"></font></span></font></td>
				<td width="21" height="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V10" name="q13"></font></span></font></td>
				<td width="213" height="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V11" name="q13"></font></span></font></td>
			</tr>
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">14. I am able to apply this 
				knowledge to my job</font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V7" name="q14" checked></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V8" name="q14"></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V9" name="q14"></font></span></font></td>
				<td width="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V10" name="q14"></font></span></font></td>
				<td width="213"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V11" name="q14"></font></span></font></td>
			</tr>
		</table>
		<p style="margin-bottom: -10px"> </p>
		<p align="left" style="line-height: 1px; margin-top: 10px; margin-bottom: 0">
		<font face="Verdana" style="font-size: 9pt">What did you like best about the training?</font></p>
		<p align="left" style="line-height: 1px; margin-top: 10px; margin-bottom: 0">
		<font size="1" face="Verdana"><span style="font-size: 9pt"><textarea rows="3" name="txtQ15" cols="45"></textarea></span></font></p>
		<p align="left" style="line-height: 1px; margin-top: 10px; margin-bottom: 0"> </p>
		<p align="left" style="line-height: 1px; margin-top: 10px; margin-bottom: 0">
		<font face="Verdana" style="font-size: 9pt">How can we improve this training?</font></p>
		<p align="left" style="line-height: 1px; margin-top: 10px; margin-bottom: 0">
		<font face="Verdana" style="font-size: 8pt">(logistics, content, trainer, material, 
		facilities...)</font></p>
		<p align="left" style="line-height: 1px; margin-top: 10px; margin-bottom: 0">
		<font size="1" face="Verdana"><span style="font-size: 9pt"><textarea rows="3" name="txtQ16" cols="45"></textarea></span></font></p>
		</td>
		


		<td height="925" width="5"></td>
	
	</tr>
	</table>
		</td>
    </tr>
  </table>
  <p align="left">
	<img border="0" src="images/Right_6.gif" width="31" height="19"><input type="submit" value="Submit" name="Submit"></p>



</form>

<%else %>
<% 
Dim ConnectString
Dim rst
Dim strSQL
Dim objConn
Dim R1_1
Dim R2_1
Dim R3_1
Dim R4_1
Dim RNA_1


R1_1=request.form("q1")
R2_1=request.form("q1")
R3_1=request.form("q1")
R4_1=request.form("q1")
RNA_1=request.form("q1")

'open database 
ConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("\mysite18\survey\fpdb\survey.mdb")
Set objConn = Server.CreateObject("ADODB.Connection") 
objConn.Open ConnectString 


strSQL = "UPDATE Results SET R1="&R1_1&"+1, R2="&R2_1&"+1, R3="&R3_1&"+1, R4="&R4_1&"+1, RNA="&RNA_1&"+1 WHERE (QUESTION_NO=1);"
objConn.Execute (strSQL)

rst.close
set rst=nothing
objConn.close
set objConn=nothing
		

%> 



<table border="0" cellpadding="0" cellspacing="0" width="100%">
  <tr>
    <td width="100%">
      <table border="0" cellpadding="0" cellspacing="0" width="100%">
        <tr>
          <td width="100%">

</td>
        </tr>
      </table>
      <table border="0" cellpadding="0" cellspacing="0" width="100%">
        <tr>
          <td width="100%">
            <p align="left"> <p align="left">    
			<span style="background-color: #99CCFF"><b>
			<font face="Blackadder ITC" style="font-size: 38pt">
			<marquee behavior="alternate" width="559">Thank You</marquee></font></b></span><p align="left"> </td>
        </tr>
      </table>
      <table border="0" cellpadding="0" cellspacing="0" width="100%">
        <tr>
          <td width="100%"><p align="left">
		<font face="Cambria"><span style="background-color: #FFFFFF">       
		<img border="0" src="images/Flashing_snowflakes.gif" width="539" height="16">                                                </span> </font> </p>
			<p align="left">
		<span style="background-color: #FFFFFF"><font face="Cambria">                                               
		<font color="#808080"> </font></font></span><font face="Cambria" color="#808080"><span style="background-color: #FFFFFF">Thank you 
		for taking the survey. </span> </font> </p>
				<p><font color="#808080"><span style="background-color: #FFFFFF">       
				</span> <font face="Cambria">
				<span style="background-color: #FFFFFF"> We value your input and will use your responses to help improve 
				our offering.</span></font></font><p> </td>
        </tr>
      </table>
      <p>  <a href="mainPage.asp"><img border="0" src="images/Flashing_arrow.gif" width="53" height="35"></a>  </p>
		<p> </p>
      <table border="0" cellpadding="0" cellspacing="0" width="100%">
        <tr>
          <td width="100%">



</td>
        </tr>
      </table>
      <p> </td>
  </tr>
 
</table>
  
</body>

</html>

<%end if%><!--#include file="footer.asp"-->


this is the error showing 
Error Type:
Microsoft JET Database Engine (0x80004005)
Unspecified error
/mysite18/survey/trainingQ.asp, line 483


Line 483 is 
objConn.Open ConnectString





William Lee -> RE: No value given for one or more required parameters. (9/26/2007 5:41:06)


hi gantan,
in line 483, you seem to use a method usually with Recordset. In this case you are dealing with the Connection object.

Can u change the line [ objConn.Open ConnectString ] to two lines as below and try?

objConn.ConnectionString= ConnectString
objConn.Open




William Lee -> RE: No value given for one or more required parameters. (9/26/2007 6:06:44)


quote:

ORIGINAL: gantan



quote:

sql = "UPDATE AnswerTraining SET R1= "&R1_1&" +1, R2= "&R2_1&" +1, R3= "&R3_1&" +1, R4= "&R4_1&" +1, RNA= "&RNA_1&" +1 WHERE QUESTION_NO=1"
objConn.execute sql


This sql mean that, when the respondent click for any one of the radio button, it will add 1 into the column. Do you get what i mean??

It is got others way to doing?



Lets work on your sql. I think you need only to update 1 column at any one time.

You must first determine what VALUE is returned by the q1 radiobuttons.

You also need to retrieve the current value of each column.

Below is a rough guide, you must do the necessary Dim and creating of serverobject for recordsets.
_________________
Dim RadioValue

RadioValue = Request.Form("q1")


rst.open "Select * from AnswerTraining where Question_No=1"


SELECT CASE RadioValue

Case "R1_1"
sql="Update AnswerTraining Set R1=rst("R1") + 1 Where Question_No=1"

Case "R2_1"
sql="Update AnswerTraining set R2=rst("R2") +1 where Question_No=1"


...and so on.

Then you execute the sql against the connection.

I hope I give you a good picture. You must perform all the necessary Dim and Server.CreateObjects



gantan -> RE: No value given for one or more required parameters. (9/26/2007 22:24:20)

Seem like your method is more logic than me. Thank so much :) 

<% 
Dim ConnectString
Dim objConn

'open database 
ConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("\onlineSurvey\mysite18\survey\fpdb\survey.mdb")
Set objConn = Server.CreateObject("ADODB.Connection") 
objConn.ConnectionString= ConnectString 
objConn.Open 

Dim rst   
Set rst=Server.CreateObject("ADODB.Recordset") 
Dim RadioValue 
Dim sql
RadioValue = Request.Form("q1") 
rst.open ("Select * from Results Where QUESTION_NO=1") 

SELECT CASE RadioValue 

Case "R1_1" 
sql="Update Results Set R1=rst(R1)+1 Where QUESTION_NO=1" 

Case "R2_1" 
sql="Update Results Set R2=rst(R2) + 1 Where QUESTION_NO=1" 

Case "R3_1" 
sql="Update Results Set R2=rst(R3) + 1 Where QUESTION_NO=1"

Case "R4_1" 
sql="Update Results Set R2=rst(R4) + 1 Where QUESTION_NO=1"

Case Else
sql="Update Results Set R2=rst(RNA) + 1 Where QUESTION_NO=1"

end SELECT

objConn.Execute (sql)

rst.close
set rst=nothing
objConn.close
set objConn=nothing


I change everything that you suggest. Now get this error 
ADODB.Recordset error '800a0e7d' 

The connection cannot be used to perform this operation. It is either closed or invalid in this context. 

/onlineSurvey/mysite18/survey/trainingQ.asp, line 477

Line 477 is 
rst.open ("Select * from Results Where QUESTION_NO=1")



William Lee -> RE: No value given for one or more required parameters. (9/26/2007 22:47:03)

quote:


ADODB.Recordset error '800a0e7d' 

The connection cannot be used to perform this operation. It is either closed or invalid in this context. 

/onlineSurvey/mysite18/survey/trainingQ.asp, line 477

Line 477 is 
rst.open ("Select * from Results Where QUESTION_NO=1")



We left out the connectionstring for the rst. Try

rst.open ("Select * from Results Where QUESTION_NO=1") , ConnectString


Another thing - you have used R2 in Case "R3_1" onwards, pls check if it is a mistake.



gantan -> RE: No value given for one or more required parameters. (9/26/2007 23:09:34)

oh.. thank.Good catch..
But now get this error: 
Undefined function 'rst' in expressionon
lineSurvey/mysite18/survey/trainingQ.asp, line 497


Line 497 ->
objConn.Execute (sql)



William Lee -> RE: No value given for one or more required parameters. (9/26/2007 23:16:01)


quote:

ORIGINAL: gantan

oh.. thank.Good catch..
But now get this error: 
Undefined function 'rst' in expressionon
lineSurvey/mysite18/survey/trainingQ.asp, line 497


Line 497 ->
objConn.Execute (sql)



You need to change rst(R1) to rst("R1"). Do the same for the rest, ie add the double quote marks.



gantan -> RE: No value given for one or more required parameters. (9/26/2007 23:21:26)

Get this errir -> 
Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/mysite18/survey/trainingQ.asp, line 482, column 32
sql="Update Results Set R1=rst("R1")+1 Where QUESTION_NO=1"
-------------------------------^




William Lee -> RE: No value given for one or more required parameters. (9/26/2007 23:27:25)


quote:

ORIGINAL: gantan

Get this errir -> 
Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/mysite18/survey/trainingQ.asp, line 482, column 32
sql="Update Results Set R1=rst("R1")+1 Where QUESTION_NO=1"
-------------------------------^




Try single quote instead of double quote because the ones I ask you to put are interfering with the start and close of the sql statement



William Lee -> RE: No value given for one or more required parameters. (9/26/2007 23:34:54)

quote:

ORIGINAL: William Lee





Try single quote instead of double quote because the ones I ask you to put are interfering with the start and close of the sql statement


Sorry ignore that!

Do this. Modify your sql as follows

sql="Update Results Set R1=" & rst("R1")+1 & " Where QUESTION_NO=1"



gantan -> RE: No value given for one or more required parameters. (9/27/2007 0:50:26)

ok, i change it ready.
But now is -> 
error '80020009' 
Exception occurred. 

/onlineSurvey/mysite18/survey/trainingQ.asp, line 482


line 482 is -> 
sql="Update Results Set R1="&rst("R1")+1&" Where QUESTION_NO=1"



Thank :)



William Lee -> RE: No value given for one or more required parameters. (9/27/2007 0:59:45)


quote:

ORIGINAL: gantan

ok, i change it ready.
But now is -> 
error '80020009' 
Exception occurred. 

/onlineSurvey/mysite18/survey/trainingQ.asp, line 482


line 482 is -> 
sql="Update Results Set R1="&rst("R1")+1&" Where QUESTION_NO=1"



Thank :)



Put a space between places when it is essential to tell they are separate.

&rst("R1")+1& reads like they are one long string - error prone.

Change &rst("R1")+1& to & rst("R1") + 1 & and see if any better results



gantan -> RE: No value given for one or more required parameters. (9/27/2007 1:05:11)

same error will occur :(



William Lee -> RE: No value given for one or more required parameters. (9/27/2007 1:07:03)

Do u actually have a question no 1 in your database?



gantan -> RE: No value given for one or more required parameters. (9/27/2007 1:22:30)

Oh ya.. i forgot to put it. Thank :)
But now come to this error... 
Microsoft JET Database Engine error '80004005' 

Operation must use an updateable query. 

/onlineSurvey/mysite18/survey/trainingQ.asp, line 497


line 497 -> 
objConn.Execute (sql)



William Lee -> RE: No value given for one or more required parameters. (9/27/2007 1:34:24)

quote:

Microsoft JET Database Engine error '80004005'

Operation must use an updateable query.


This has got to do with permissions and not easily solved because it can mean alot of things.
I suggest you do a search for this phrase
error '80004005' Operation must use an updateable query then check with yr system administrator abt it.



gantan -> RE: No value given for one or more required parameters. (9/27/2007 1:40:21)

oh, that mean all the coding is correct. What i should do is get permission from admin..
ok, thank a lot, William.
I learn many from you... :)



William Lee -> RE: No value given for one or more required parameters. (9/27/2007 1:46:10)

Will you be so kind as to post your complete ASP code that we have changed so far?




gantan -> RE: No value given for one or more required parameters. (9/27/2007 1:48:17)

Sure.. :) 

<% OPTION EXPLICIT
Response.Buffer = True
 %>
<!--#include file="header.asp"-->

<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Survey1</title>
</head>

<body>
<% if len(request.form("Submit"))<=0 then %>

<p>
<b><font face="Bodoni Black" size="6"><span style="background-color: #99CCFF"> <marquee behavior="slide" width="582">Training Survey</marquee></span></font></b></p>
<form method="POST" action="--WEBBOT-SELF--">
	
  <table border="0" cellpadding="0" cellspacing="0" width="100%" height="279">
    <tr>
      <td width="100%" height="1">

<table border="0" cellpadding="0" cellspacing="0" width="799" height="991" id="table45">
	<!-- MSTableType="layout" -->
	<tr>
		<td valign="top" height="62" colspan="2">
		<!-- MSCellType="ContentHead2" -->
		<p style="margin-top: 0; margin-bottom: 0">
<font size="1" face="Verdana">Please make 
		sure to fill in ALL information below:</font></p>
		<p style="margin-top: 0; margin-bottom: 0">
		<font size="1" face="Verdana">This 
		Evaluation is completely confidential, please feel free to answer 
		honestly.</font></p>
		<p style="line-height: 0"> </td>
	</tr>
	<tr>
		<td></td>
		<td height="4"></td>
	</tr>
	<tr>
		<td valign="top" width="794">
		<!-- MSCellType="ContentBody" -->
		<p align="left" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="left" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="left" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="left" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<table border="0" width="100%" id="table46" cellspacing="0" cellpadding="0">
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">Course Name :</font></td>
				<td><font size="1" face="Verdana"><span style="font-size: 9pt">
				<input type="text" name="txtCourseName" size="29"></span></font></td>
			</tr>
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">Course Date :</font></td>
				<td><font size="1" face="Verdana"><span style="font-size: 9pt">
				<input type="text" name="txtCourseDate" size="29"></span></font></td>
			</tr>
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">Name :</font></td>
				<td><font size="1" face="Verdana"><span style="font-size: 9pt">
				<input type="text" name="txtName" size="29"></span></font></td>
			</tr>
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">Trainer :</font></td>
				<td><font size="1" face="Verdana"><span style="font-size: 9pt">
				<input type="text" name="txtTrainer" size="29"></span></font></td>
			</tr>
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">Market Segment :</font></td>
				<td>
				<p style="margin-bottom: -20px"><font size="1" face="Verdana">
				<span style="font-size: 9pt">
				<input type="radio" value="V5" name="b1"></span></font><font face="Verdana" style="font-size: 9pt">  EMT</font></p>
				<p style="margin-bottom: -20px"><font size="1" face="Verdana">
				<span style="font-size: 9pt">
				<input type="radio" value="V6" name="b1"></span></font><font face="Verdana" style="font-size: 9pt">  Automotive</font></p><p style="margin-bottom: -20px">
				<font size="1" face="Verdana"><span style="font-size: 9pt">
				<input type="radio" value="V7" name="b1"></span></font><font face="Verdana" style="font-size: 9pt">  Wireless</font><p style="margin-bottom: -20px"> </td>
			</tr>
		</table>
		<p align="left" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="left" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		___________________________________________________________________________________</p>
		<p align="left" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="left" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="left" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="left" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="left" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="left" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="center" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="center" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="center" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="center" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="center" style="line-height: 0; margin-top: 2px; margin-bottom: 2px">
		 </p>
		<p align="left" style="line-height: 1px; margin-top: 10px; margin-bottom: 0">
		<font face="Verdana" size="1">Please click your response to the items. 
		Rate aspects of the course on a 1 to 4 scale 1 equals "strongly 
		disagree" </font></p>
		<p align="left" style="line-height: 1px; margin-top: 10px; margin-bottom: 0">
		<font face="Verdana" size="1">and 4 "strongly agree." Choose N/A if the 
		item is not applicable to this course. Your feedback is sincerely 
		appreciated</font></p>
		<p align="left" style="line-height: 1px; margin-top: 10px; margin-bottom: 0">
		<font face="Verdana" size="1">Thank you. </font></p>
		<p align="left" style="line-height: 1px"><b>
		<font face="Verdana" size="1">1= Strongly disagree, 2= Disagree, 3= 
		Agree, 4= Strongly agree, NA= Not applicable</font></b></p>
		<p align="center" style="line-height: 1px"><b>
		<font face="Tahoma" size="1"> </font></b></p>
		<table border="0" width="100%" id="table47" cellspacing="0" cellpadding="0">
			<tr>
				<td><b><font face="Verdana" style="font-size: 9pt">Quality of Logistics</font></b></td>
				<td width="20"><b><font face="Verdana" size="1">  1</font></b></td>
				<td width="21"><b><font face="Verdana" size="1"> 2</font></b></td>
				<td width="20"><b><font face="Verdana" size="1"> 3   </font>
				</b></td>
				<td width="22"><b><font face="Verdana" size="1"> 4  
				</font></b></td>
				<td width="213"><b><font face="Verdana" size="1"> NA                       </font>
				</b></td>
			</tr>
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">1. Logistical registration 
				process was effective</font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="R1_1" name="q1"></font></span></font></td>
				<td width="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="R2_1" name="q1"></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="Q3_1" name="q1"></font></span></font></td>
				<td width="22"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="R4_1" name="q1"></font></span></font></td>
				<td width="213"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="RNA_1" name="q1"></font></span></font></td>
			</tr>
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">2. Training Material was 
				accessible before the course began</font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V11" name="q2" checked></font></span></font></td>
				<td width="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V12" name="q2"></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V13" name="q2"></font></span></font></td>
				<td width="22"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V14" name="q2"></font></span></font></td>
				<td width="213"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V15" name="q2"></font></span></font></td>
			</tr>
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">3. Classroom facilities were 
				satisfactory</font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V11" name="q3" checked></font></span></font></td>
				<td width="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V12" name="q3"></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V13" name="q3"></font></span></font></td>
				<td width="22"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V14" name="q3"></font></span></font></td>
				<td width="213"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V15" name="q3"></font></span></font></td>
			</tr>
		</table>
		<p align="justify" style="line-height: 1px; margin-top:6px; margin-bottom:2px"> </p>
		<p align="justify" style="line-height: 1px; margin-top:6px; margin-bottom:2px"> </p>
		<p align="justify" style="line-height: 1px; margin-top:6px; margin-bottom:2px"> </p>
		<table border="0" width="100%" id="table48" cellspacing="0" cellpadding="0">
			<tr>
				<td><font face="Verdana" style="font-size: 9pt"><b>Course Content  </b>                                                         
				</font></td>
			</tr>
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">4. The course was useful</font></td>
				<td width="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V7" name="q4" checked></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V8" name="q4"></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V9" name="q4"></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V10" name="q4"></font></span></font></td>
				<td width="214"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V11" name="q4"></font></span></font></td>
			</tr>
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">5. The objective were clear</font></td>
				<td width="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V7" name="q5" checked></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V8" name="q5"></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V9" name="q5"></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V10" name="q5"></font></span></font></td>
				<td width="214"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V11" name="q5"></font></span></font></td>
			</tr>
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">6. The length was appropriate</font></td>
				<td width="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V7" name="q6" checked></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V8" name="q6"></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V9" name="q6"></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V10" name="q6"></font></span></font></td>
				<td width="214"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V11" name="q6"></font></span></font></td>
			</tr>
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">7. The level of the test was 
				acceptable</font></td>
				<td width="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V7" name="q7" checked></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V8" name="q7"></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V9" name="q7"></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V10" name="q7"></font></span></font></td>
				<td width="214"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V11" name="q7"></font></span></font></td>
			</tr>
		</table>
		<p style="margin-bottom: -10px"> </p>
		<table border="0" width="100%" id="table49" cellspacing="0" cellpadding="0">
			<tr>
				<td width="500"><font face="Verdana" style="font-size: 9pt"><b>About the Trainer</b>              
				</font></td>
			</tr>
			<tr>
				<td width="500"><font face="Verdana" style="font-size: 9pt">8. The trainer explained in a 
				clear way</font></td>
				<td bgcolor="#FFFFFF"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V7" name="q8" checked></font></span></font></td>
				<td bgcolor="#FFFFFF" width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V8" name="q8"></font></span></font></td>
				<td bgcolor="#FFFFFF" width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V9" name="q8"></font></span></font></td>
				<td bgcolor="#FFFFFF" width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V10" name="q8"></font></span></font></td>
				<td bgcolor="#FFFFFF" width="214"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V11" name="q8"></font></span></font></td>
			</tr>
			<tr>
				<td width="500"><font face="Verdana" style="font-size: 9pt">9. The trainer covered the 
				topics in course description </font></td>
				<td bgcolor="#FFFFFF"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V7" name="q9" checked></font></span></font></td>
				<td bgcolor="#FFFFFF" width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V8" name="q9"></font></span></font></td>
				<td bgcolor="#FFFFFF" width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V9" name="q9"></font></span></font></td>
				<td bgcolor="#FFFFFF" width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V10" name="q9"></font></span></font></td>
				<td bgcolor="#FFFFFF" width="214"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V11" name="q9"></font></span></font></td>
			</tr>
			<tr>
				<td width="500"><font face="Verdana" style="font-size: 9pt">10. The trainer made the 
				session dynamic and interactive</font></td>
				<td bgcolor="#FFFFFF"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V7" name="q10" checked></font></span></font></td>
				<td bgcolor="#FFFFFF" width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V8" name="q10"></font></span></font></td>
				<td bgcolor="#FFFFFF" width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V9" name="q10"></font></span></font></td>
				<td bgcolor="#FFFFFF" width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V10" name="q10"></font></span></font></td>
				<td bgcolor="#FFFFFF" width="214"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V11" name="q10"></font></span></font></td>
			</tr>
			<tr>
				<td width="500"><font face="Verdana" style="font-size: 9pt">11. The trainer demonstrated 
				in-depth knowledge about the topic</font></td>
				<td bgcolor="#FFFFFF"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V7" name="q11" checked></font></span></font></td>
				<td bgcolor="#FFFFFF" width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V8" name="q11"></font></span></font></td>
				<td bgcolor="#FFFFFF" width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V9" name="q11"></font></span></font></td>
				<td bgcolor="#FFFFFF" width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V10" name="q11"></font></span></font></td>
				<td bgcolor="#FFFFFF" width="214"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V11" name="q11"></font></span></font></td>
			</tr>
		</table>
		<p style="margin-bottom: -10px"> </p>
		<table border="0" width="100%" id="table50" cellspacing="0" cellpadding="0">
			<tr>
				<td><font face="Verdana" style="font-size: 9pt"><b>Impact on Performance</b>                                                 
				</font></td>
			</tr>
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">12. The course has given to me 
				a broader knowledge</font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V7" name="q12" checked></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V8" name="q12"></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V9" name="q12"></font></span></font></td>
				<td width="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V10" name="q12"></font></span></font></td>
				<td width="213"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V11" name="q12"></font></span></font></td>
			</tr>
			<tr>
				<td height="21"><font face="Verdana" style="font-size: 9pt">13. The course helps to 
				correct my weaknesses </font></td>
				<td width="20" height="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V7" name="q13" checked></font></span></font></td>
				<td width="20" height="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V8" name="q13"></font></span></font></td>
				<td width="20" height="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V9" name="q13"></font></span></font></td>
				<td width="21" height="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V10" name="q13"></font></span></font></td>
				<td width="213" height="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V11" name="q13"></font></span></font></td>
			</tr>
			<tr>
				<td><font face="Verdana" style="font-size: 9pt">14. I am able to apply this 
				knowledge to my job</font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V7" name="q14" checked></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V8" name="q14"></font></span></font></td>
				<td width="20"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V9" name="q14"></font></span></font></td>
				<td width="21"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V10" name="q14"></font></span></font></td>
				<td width="213"><font size="1" face="Verdana">
				<span style="font-size: 9pt"><font size="1">
				<input type="radio" value="V11" name="q14"></font></span></font></td>
			</tr>
		</table>
		<p style="margin-bottom: -10px"> </p>
		<p align="left" style="line-height: 1px; margin-top: 10px; margin-bottom: 0">
		<font face="Verdana" style="font-size: 9pt">What did you like best about the training?</font></p>
		<p align="left" style="line-height: 1px; margin-top: 10px; margin-bottom: 0">
		<font size="1" face="Verdana"><span style="font-size: 9pt"><textarea rows="3" name="txtQ15" cols="45"></textarea></span></font></p>
		<p align="left" style="line-height: 1px; margin-top: 10px; margin-bottom: 0"> </p>
		<p align="left" style="line-height: 1px; margin-top: 10px; margin-bottom: 0">
		<font face="Verdana" style="font-size: 9pt">How can we improve this training?</font></p>
		<p align="left" style="line-height: 1px; margin-top: 10px; margin-bottom: 0">
		<font face="Verdana" style="font-size: 8pt">(logistics, content, trainer, material, 
		facilities...)</font></p>
		<p align="left" style="line-height: 1px; margin-top: 10px; margin-bottom: 0">
		<font size="1" face="Verdana"><span style="font-size: 9pt"><textarea rows="3" name="txtQ16" cols="45"></textarea></span></font></p>
		</td>
		


		<td height="925" width="5"></td>
	
	</tr>
	</table>
		</td>
    </tr>
  </table>
  <p align="left">
	<img border="0" src="images/Right_6.gif" width="31" height="19"><input type="submit" value="Submit" name="Submit"></p>



</form>

<%else %>
<% 
Dim ConnectString
Dim objConn

'open database 
ConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("c:\Inetpub\wwwroot\mysite18\survey\fpdb\survey.mdb")
Set objConn = Server.CreateObject("ADODB.Connection") 
objConn.ConnectionString= ConnectString 
objConn.Open 

Dim rst   
Set rst=Server.CreateObject("ADODB.Recordset") 
Dim RadioValue 
Dim sql
RadioValue = Request.Form("q1") 
rst.open ("Select * from Results Where QUESTION_NO=1"), ConnectString

SELECT CASE RadioValue 

Case "R1_1" 
sql="Update Results Set R1="& rst("R1") + 1 &" Where QUESTION_NO=1" 

Case "R2_1" 
sql="Update Results Set R2="& rst("R2") + 1 &" Where QUESTION_NO=1" 

Case "R3_1" 
sql="Update Results Set R3="& rst("R3") + 1 &" Where QUESTION_NO=1"

Case "R4_1" 
sql="Update Results Set R4="& rst("R4") + 1 &" Where QUESTION_NO=1"

Case "RNA_1"
sql="Update Results Set RNA="& rst("RNA") + 1 &" Where QUESTION_NO=1"

End SELECT
objConn.Execute (sql)

rst.close
set rst=nothing
objConn.close
set objConn=nothing
		

%> 



<table border="0" cellpadding="0" cellspacing="0" width="100%">
  <tr>
    <td width="100%">
      <table border="0" cellpadding="0" cellspacing="0" width="100%">
        <tr>
          <td width="100%">

</td>
        </tr>
      </table>
      <table border="0" cellpadding="0" cellspacing="0" width="100%">
        <tr>
          <td width="100%">
            <p align="left"> <p align="left">    
			<span style="background-color: #99CCFF"><b>
			<font face="Blackadder ITC" style="font-size: 38pt">
			<marquee behavior="alternate" width="559">Thank You</marquee></font></b></span><p align="left"> </td>
        </tr>
      </table>
      <table border="0" cellpadding="0" cellspacing="0" width="100%">
        <tr>
          <td width="100%"><p align="left">
		<font face="Cambria"><span style="background-color: #FFFFFF">       
		<img border="0" src="images/Flashing_snowflakes.gif&