|
| |
|
|
gantan
Posts: 50
Joined: 9/19/2007
Status: offline
 |
RE: No value given for one or more required parameters. - 9/28/2007 1:58:11
Hello, William. Me again.
I ask from administrator, they had apply permission for me.
But still get the same error...:(
Do you have any idea ??
|
|
|
|
William Lee
Posts: 1041
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: No value given for one or more required parameters. - 9/28/2007 6:41:24
quote:
ORIGINAL: gantan
Hello, William. Me again.
I ask from administrator, they had apply permission for me.
But still get the same error...:(
Do you have any idea ??
I checked your code and noticed you already had the physical path to the survey.mdb, in which case you do not need to use Server.MapPath.
Do you have any URL to show this online survey?
Have you carried out my suggestion to do a search and then, based on the search results, go discuss with your IT department? They said they gave you permission, but precisely what permissions are they referring to?
What user permissions have they given for the folder that the survey.mdb is located? What permissions for the mdb file?
Please understand the code is not the only thing why your survey is not working till now. Permissions is one thing, database design is another. Do you remember you don't even have a question no. 1 in your database?
So many things.
Now, can you email me your survey.mdb or put it on an URL that I can download?
Alright, we do some changes to your code and see how successful we can be.
When the rst.Open ("Select * from Results where Question_No=1") is carried out, you write those recordsets into variables, like these:
Dim varr1, varr2 ..etc etc
varr1=rst("R1") +1
varr2=rst("R2") +1
...etc etc
After the last one, you CLOSE the rst before the SELECT CASE segment.
Change sql for CASE "R1_1" like this:
sql="Update Results Set R1=" & varr1 & " Where Question_No=1"
Change correspondingly for all the rest.
I am suspecting the survey.mdb file is locked by the rst.Open. This resulted in error when the line objConn.Execute attempts to update a database that has been locked.
Do you understand? Try it.
< Message edited by William Lee -- 9/29/2007 3:53:16 >
| |
|
|
|
William Lee
Posts: 1041
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: No value given for one or more required parameters. - 9/30/2007 0:50:05
quote:
ORIGINAL: gantan
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..
I think you have lost a lot of time on this. While your IT department may be sorting out the permissions thing or you are waiting for advice from others, I suggest that you work on the chart in the meantime.
Go populate the database with some data manually using MS Access and start making your chart.
You may think that the chart is a simple or straightforward thing but you may never know what problems can surface. Don't assume. Be proactive.
This way you save yourself time.
< Message edited by William Lee -- 9/30/2007 2:10:35 >
| |
|
|
|
gantan
Posts: 50
Joined: 9/19/2007
Status: offline
|
RE: No value given for one or more required parameters. - 9/30/2007 20:56:38
Sorry for late reply.
Later i will discuss with administrator again.
Can you give me your email address? So that I can email my project to you...
Thank you very much for everthing.. :)
| |
|
|
|
gantan
Posts: 50
Joined: 9/19/2007
Status: offline
|
RE: No value given for one or more required parameters. - 10/2/2007 20:46:21
Hello William, this is my latest code.
<%Option Explicit%>
<%Response.Buffer = True%>
<!--#include file="header.asp"-->
<html>
<head><title>Survey1</title>
</head>
<body>
<% if len(request.form("Submit"))<=0 then %>
<form method="post">
<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>
<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 connectionstring
Dim objConn
Dim rst
connectionstring="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Inetpub\wwwroot\mysite18\survey\fpdb\survey.mdb;Persist Security Info=False"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Mode = 3
objConn.ConnectionString = connectionstring
objConn.open connectionstring
Set rst=Server.CreateObject("ADODB.Recordset")
Dim RadioValue
Dim sql
RadioValue = Request.Form("q1")
rst.open ("Select * from Results Where QUESTION_NO=1"), connectionstring
Dim varr1, varr2, varr3, varr4, varrNA
varr1 = rst("R1")+1
varr2 = rst("R2")+1
varr3 = rst("R3")+1
varr4 = rst("R4")+1
varrNA = rst("RNA")+1
rst.close
set rst=nothing
SELECT CASE RadioValue
Case "R1_1"
sql="Update Results Set R1="& varr1 &" Where QUESTION_NO=1"
Case "R2_1"
sql="Update Results Set R2="& varr2 &" Where QUESTION_NO=1"
Case "R3_1"
sql="Update Results Set R3="& varr3 &" Where QUESTION_NO=1"
Case "R4_1"
sql="Update Results Set R4="& varr4 &" Where QUESTION_NO=1"
Case "RNA_1"
sql="Update Results Set RNA="& varrNA &" Where QUESTION_NO=1"
End SELECT
objConn.Execute(sql)
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"-->
Thank
| |
|
|
|
William Lee
Posts: 1041
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: No value given for one or more required parameters. - 10/2/2007 20:49:36
So did you run the code? what errors you get?
_____________________________
William Lee
| |
|
|
|
gantan
Posts: 50
Joined: 9/19/2007
Status: offline
|
RE: No value given for one or more required parameters. - 10/2/2007 20:54:06
same error.
Microsoft JET Database Engine (0x80004005)
Unspecified error
/mysite18/survey/trainingQ.asp, line 464
line 464 is objConn.open connectionstring
| |
|
|
|
William Lee
Posts: 1041
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: No value given for one or more required parameters. - 10/2/2007 21:02:34
quote:
ORIGINAL: gantan
same error.
Microsoft JET Database Engine (0x80004005)
Unspecified error
/mysite18/survey/trainingQ.asp, line 464
line 464 is objConn.open connectionstring
Previously you use the word connectstring, now you have changed it to connectionstring. This word 'ConnectionString' is a member of the Connection object, may be a RESERVED word. Can you change back or use another word.
_____________________________
William Lee
| |
|
|
|
gantan
Posts: 50
Joined: 9/19/2007
Status: offline
|
RE: No value given for one or more required parameters. - 10/2/2007 21:10:09
ok, i change it to :
<%
Else
Dim ConnectString
Dim objConn
Dim rst
ConnectString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Inetpub\wwwroot\mysite18\survey\fpdb\survey.mdb;Persist Security Info=False"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Mode = 3
objConn.ConnectionString= ConnectString
objConn.Open
Set rst=Server.CreateObject("ADODB.Recordset")
Dim RadioValue
Dim sql
RadioValue = Request.Form("q1")
rst.open ("Select * from Results Where QUESTION_NO=1"), ConnectString
Dim varr1, varr2, varr3, varr4, varrNA
varr1 = rst("R1")+1
varr2 = rst("R2")+1
varr3 = rst("R3")+1
varr4 = rst("R4")+1
varrNA = rst("RNA")+1
rst.close
set rst=nothing
SELECT CASE RadioValue
Case "R1_1"
sql="Update Results Set R1="& varr1 &" Where QUESTION_NO=1"
Case "R2_1"
sql="Update Results Set R2="& varr2 &" Where QUESTION_NO=1"
Case "R3_1"
sql="Update Results Set R3="& varr3 &" Where QUESTION_NO=1"
Case "R4_1"
sql="Update Results Set R4="& varr4 &" Where QUESTION_NO=1"
Case "RNA_1"
sql="Update Results Set RNA="& varrNA &" Where QUESTION_NO=1"
End SELECT
objConn.Execute(sql)
objConn.close
set objConn=nothing
%>
but get same error.
So, it is the permission problem? Untill now the IT staff still cannot give me the answer about what kind of permission that they given to me. They kick me like a ball, A call me to ask B, B call me to ask C, C call me to ask back A...
| |
|
|
|
William Lee
Posts: 1041
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: No value given for one or more required parameters. - 10/2/2007 21:20:28
Is your physical path correct?
Put this in a empty test asp page and see what is returned?
<% Response.Write (Server.MapPath("survey.mdb")%>
_____________________________
William Lee
| |
|
|
|
gantan
Posts: 50
Joined: 9/19/2007
Status: offline
|
RE: No value given for one or more required parameters. - 10/2/2007 21:34:51
c:\inetpub\wwwroot\mysite18\survey\fpdb\survey.mdb
Then i change the 'I'netpub to inetpub.
But same error occur.
| |
|
|
|
William Lee
Posts: 1041
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: No value given for one or more required parameters. - 10/2/2007 21:45:18
quote:
ORIGINAL: gantan
c:\inetpub\wwwroot\mysite18\survey\fpdb\survey.mdb
Then i change the 'I'netpub to inetpub.
But same error occur.
How can it be same error? there is no more "objconn.open connectionstring" in your latest code.
what is the actual error msg?
_____________________________
William Lee
| |
|
|
|
gantan
Posts: 50
Joined: 9/19/2007
Status: offline
|
RE: No value given for one or more required parameters. - 10/2/2007 22:01:51
<%
Else
Dim ConnectString
Dim objConn
Dim rst
ConnectString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\wwwroot\mysite18\survey\fpdb\survey.mdb"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Mode = 3
objConn.ConnectionString= ConnectString
objConn.Open ConnectString
Set rst=Server.CreateObject("ADODB.Recordset")
Dim RadioValue
Dim sql
RadioValue = Request.Form("q1")
rst.open ("Select * from Results Where QUESTION_NO=1"), ConnectString
Dim varr1, varr2, varr3, varr4, varrNA
varr1 = rst("R1")+1
varr2 = rst("R2")+1
varr3 = rst("R3")+1
varr4 = rst("R4")+1
varrNA = rst("RNA")+1
rst.close
set rst=nothing
SELECT CASE RadioValue
Case "R1_1"
sql="Update Results Set R1="& varr1 &" Where QUESTION_NO=1"
Case "R2_1"
sql="Update Results Set R2="& varr2 &" Where QUESTION_NO=1"
Case "R3_1"
sql="Update Results Set R3="& varr3 &" Where QUESTION_NO=1"
Case "R4_1"
sql="Update Results Set R4="& varr4 &" Where QUESTION_NO=1"
Case "RNA_1"
sql="Update Results Set RNA="& varrNA &" Where QUESTION_NO=1"
End SELECT
objConn.Execute(sql)
objConn.close
set objConn=nothing
%>
This is the error message
Technical Information (for support personnel)
Error Type:
Microsoft JET Database Engine (0x80004005)
Unspecified error
/mysite18/survey/trainingQ.asp, line 464
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; Agilent Technologies IE6 SP1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727)
Page:
POST 173 bytes to /mysite18/survey/trainingQ.asp
POST Data:
txtCourseName=&txtCourseDate=&txtName=&txtTrainer=&q1=R1_1&q2=V11&q3=V11&q4=V7&q5=V7&q6=V7&q7=V7&q8=V7&q9=V7&q10=V7&q11=V7&q12=V7&q13=V7&q14=V7&txtQ15=&txtQ16=&Submit=Submit
Time:
Wednesday, October 03, 2007, 10:00:48 AM
More information:
| |
|
|
|
William Lee
Posts: 1041
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: No value given for one or more required parameters. - 10/2/2007 22:07:08
quote:
ORIGINAL: gantan
<%
Else
Dim ConnectString
Dim objConn
Dim rst
ConnectString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\wwwroot\mysite18\survey\fpdb\survey.mdb"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Mode = 3
objConn.ConnectionString= ConnectString
objConn.Open ConnectString
Set rst=Server.CreateObject("ADODB.Recordset")
Dim RadioValue
Dim sql
RadioValue = Request.Form("q1")
rst.open ("Select * from Results Where QUESTION_NO=1"), ConnectString
Dim varr1, varr2, varr3, varr4, varrNA
varr1 = rst("R1")+1
varr2 = rst("R2")+1
varr3 = rst("R3")+1
varr4 = rst("R4")+1
varrNA = rst("RNA")+1
rst.close
set rst=nothing
SELECT CASE RadioValue
Case "R1_1"
sql="Update Results Set R1="& varr1 &" Where QUESTION_NO=1"
Case "R2_1"
sql="Update Results Set R2="& varr2 &" Where QUESTION_NO=1"
Case "R3_1"
sql="Update Results Set R3="& varr3 &" Where QUESTION_NO=1"
Case "R4_1"
sql="Update Results Set R4="& varr4 &" Where QUESTION_NO=1"
Case "RNA_1"
sql="Update Results Set RNA="& varrNA &" Where QUESTION_NO=1"
End SELECT
objConn.Execute(sql)
objConn.close
set objConn=nothing
%>
This is the error message
Technical Information (for support personnel)
Error Type:
Microsoft JET Database Engine (0x80004005)
Unspecified error
/mysite18/survey/trainingQ.asp, line 464
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; Agilent Technologies IE6 SP1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727)
Page:
POST 173 bytes to /mysite18/survey/trainingQ.asp
POST Data:
txtCourseName=&txtCourseDate=&txtName=&txtTrainer=&q1=R1_1&q2=V11&q3=V11&q4=V7&q5=V7&q6=V7&q7=V7&q8=V7&q9=V7&q10=V7&q11=V7&q12=V7&q13=V7&q14=V7&txtQ15=&txtQ16=&Submit=Submit
Time:
Wednesday, October 03, 2007, 10:00:48 AM
More information:
ok, take out the connectstring from 'objconn.open connectstring'
You confuse me. Sometimes you put in, sometimes you take out.
_____________________________
William Lee
| |
|
|
|
gantan
Posts: 50
Joined: 9/19/2007
Status: offline
|
RE: No value given for one or more required parameters. - 10/2/2007 22:36:33
Sorry about that, coz i keep trying all the possible method.
I try to put it at the server and take out the ConnectString
this is the coding
<%
Else
Dim ConnectString
Dim objConn
Dim rst
ConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath ("fpdb/survey.mdb")
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Mode = 3
objConn.ConnectionString = ConnectString
objConn.Open
Set rst=Server.CreateObject("ADODB.Recordset")
Dim RadioValue
Dim sql
RadioValue = Request.Form("q1")
rst.open ("Select * from Results Where QUESTION_NO=1"), ConnectString
Dim varr1, varr2, varr3, varr4, varrNA
varr1 = rst("R1")+1
varr2 = rst("R2")+1
varr3 = rst("R3")+1
varr4 = rst("R4")+1
varrNA = rst("RNA")+1
rst.close
set rst=nothing
SELECT CASE RadioValue
Case "R1_1"
sql="Update Results Set R1="& varr1 &" Where QUESTION_NO=1"
Case "R2_1"
sql="Update Results Set R2="& varr2 &" Where QUESTION_NO=1"
Case "R3_1"
sql="Update Results Set R3="& varr3 &" Where QUESTION_NO=1"
Case "R4_1"
sql="Update Results Set R4="& varr4 &" Where QUESTION_NO=1"
Case "RNA_1"
sql="Update Results Set RNA="& varrNA &" Where QUESTION_NO=1"
End SELECT
objConn.Execute(sql)
'Response.Write (sql)
objConn.close
set objConn=nothing
%>
Get this error :
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/onlineSurvey/mysite18/survey/trainingQ.asp, line 494
line 494 is objConn.Execute(sql)
| |
|
|
|
William Lee
Posts: 1041
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: No value given for one or more required parameters. - 10/2/2007 22:36:50
quote:
ORIGINAL: gantan
Untill now the IT staff still cannot give me the answer about what kind of permission that they given to me. They kick me like a ball, A call me to ask B, B call me to ask C, C call me to ask back A...
It is only a problem with permissions or access right if the error you get = Operation must use an updateable query error.
Do the following:
In Windows 98 or ME: Right click on the MS Access file (.mdb) and uncheck the "Read-only" property.
In Windows NT, 2000 or XP: Ask your system administrator to setup full access permissions for the anonymous user account called IUSR_<Machinename> to access the database.
They should know what to do.
_____________________________
William Lee
| |
|
|
|
William Lee
Posts: 1041
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: No value given for one or more required parameters. - 10/2/2007 22:39:46
quote:
ORIGINAL: gantan
Get this error :
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/onlineSurvey/mysite18/survey/trainingQ.asp, line 494
line 494 is objConn.Execute(sql)
Ok, we cannot do anything else anymore. Just make sure your database is correctly designed.
_____________________________
William Lee
| |
|
|
|
gantan
Posts: 50
Joined: 9/19/2007
Status: offline
|
RE: No value given for one or more required parameters. - 10/2/2007 22:42:08
ok, thank so much. I will call system administrator..
Thank for settle many problem for me. :)
| |
|
|
|
gantan
Posts: 50
Joined: 9/19/2007
Status: offline
|
RE: No value given for one or more required parameters. - 10/3/2007 21:50:56
William, thank thank so much...
It work.
After i apply permission from system administrator..
Then appyl database permission, it can run.
For somebody that facing :
Database Results Wizard Error
The operation failed. If this continues, please contact your server administrator.
Please go to this link to look for details...
http://support.microsoft.com/kb/898721
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
