<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> </head> <body> <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open "c:/webdata/northwind.mdb" %> <% sql="INSERT INTO customers (programmetitle,date," sql=sql &"department,supervisorsname,supervisorsemail,supervisorsext,q1a,q1b,q1c,q2,q3,q4,q5,participantsname,employeeid,ext)" sql=sql & " VALUES " sql=sql & "('" & Request.Form("ptitle") & "'," sql=sql & "'" & Request.Form("pdate") & "'," sql=sql & "'" & Request.Form("department") & "'," sql=sql & "'" & Request.Form("sname") & "'," sql=sql & "'" & Request.Form("semail") & "'," sql=sql & "'" & Request.Form("sext") & "'," sql=sql & "'" & Request.Form("q1a") & "'," sql=sql & "'" & Request.Form("q1b") & "'," sql=sql & "'" & Request.Form("q1c") & "'," sql=sql & "'" & Request.Form("q2") & "'," sql=sql & "'" & Request.Form("q3") & "'," sql=sql & "'" & Request.Form("q4") & "'," sql=sql & "'" & Request.Form("anyc") & "'," sql=sql & "'" & Request.Form("pname") & "'," sql=sql & "'" & Request.Form("emid") & "'," sql=sql & "'" & Request.Form("ext") & "')" on error resume next conn.Execute sql,recaffected if err<>0 then Response.Write("No update permissions!") else Response.Write("<h3>" & recaffected & " record added</h3>") end if conn.close %> </body> </html> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> <style type="text/css"> <!-- .heading { font-size: 24px; } --> </style> </head> <body> <blockquote> </blockquote> <form action="post.asp" method="post"> <table width="938" height="215" border="0" align="center"> <tr> <td colspan="8" class="heading"><p align="center"><strong>The Aga Khan University</strong></p> <p> </p> <p align="center"><strong>Training Impact Form</strong><strong> </strong></p></td> </tr> <tr> <td colspan="8"> </td> </tr> <tr> <td width="228" colspan="2">Programme Title: <label></label> </td> <td><label> <input type="ptitle"/> </label></td> <td colspan="2">Date: <label> <input type="pdate"/> </label></td> <td colspan="2">Department: <input type="department"/></td> </tr> <tr> <td colspan="8"><p align="right"><strong></strong></p></td> </tr> <tr> <td colspan="2"> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td colspan="2"> </td> </tr> <tr> <td>Supervisor’s Name: </td> <td><input type="sname"/></td> <td colspan="2">Supervisor’s Email: <input type="semail"/></td> <td colspan="2">Supervisor’s Ext:</td> <td colspan="2"><input type="sext"/></td> </tr> <tr> <td colspan="6"> </td> <td colspan="2"> </td> </tr> <tr> <td colspan="8"><p><em>To be filled by Participant’s immediate supervisor (at least) a month after the training to documen</em></p> <p><em>t any change in employee's knowledge, skills or attitudes as a result of the training:</em></p></td> </tr> <tr> <td colspan="8"> </td> </tr> <tr> <td colspan="8"><p>Rate the following questions from 1 to 5:</p></td> </tr> <tr> <td colspan="8"> </td> </tr> <tr> <td colspan="8"><p><strong>(5-Strongly Agree 90 %, 4 - Agree 80 % , 3 - Somewhat Agree 70%, 2-Disagree 60% and 1- Strongly Disagree 50%) </strong></p></td> </tr> <tr> <td colspan="8"> </td> </tr> <tr> <td colspan="3">Q1. Did you see any change as a result of training in employees’ </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td colspan="3">Knowledge</td> <td width="89"><label> <input type="radio" name="q1a" value="5"/> </label></td> <td width="74"><label> <input type="radio" name="q1a" value="4"/> </label></td> <td width="72"><label> <input type="radio" name="q1a" value="3"/> </label></td> <td width="65"><label> <input type="radio" name="q1a" value="2"/> </label></td> <td width="212"><label> <input type="radio" name="q1a" value="1"/> </label></td> </tr> <tr> <td colspan="3">Skills</td> <td><label> <input type="radio" name="q1b" value="5"/> </label></td> <td><label> <input type="radio" name="q1b" value="4"/> </label></td> <td><label> <input type="radio" name="q1b" value="3"/> </label></td> <td><label> <input type="radio" name="q1b" value="2"/> </label></td> <td><label> <input type="radio" name="q1b" value="1"/> </label></td> </tr> <tr> <td colspan="3">Attitude </td> <td><label> <input type="radio" name="q1c" value="5"/> </label></td> <td><label> <input type="radio" name="q1c" value="4"/> </label></td> <td><label> <input type="radio" name="q1c" value="3"/> </label></td> <td><label> <input type="radio" name="q1c" value="2"/> </label></td> <td><label> <input type="radio" name="q1c" value="1"/> </label></td> </tr> <tr> <td colspan="3"> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td colspan="3"><p>Q2. Are you satisfied with the employee’s overall performance specific to the training need addressed in the programme?</p></td> <td><label> <input type="radio" name="q2" value="5"/> </label></td> <td><label> <input type="radio" name="q2" value="4"/> </label></td> <td><label> <input type="radio" name="q2" value="3"/> </label></td> <td><label> <input type="radio" name="q2" value="2"/> </label></td> <td><label> <input type="radio" name="q2" value="1"/> </label></td> </tr> <tr> <td colspan="3"> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td colspan="3"><p>Q3. Did the employee perform differently on the job as a result of this programme?</p></td> <td><label> <input type="radio" name="q3" value="5"/> </label></td> <td><label> <input type="radio" name="q3" value="4"/> </label></td> <td><label> <input type="radio" name="q3" value="3"/> </label></td> <td><label> <input type="radio" name="q3" value="2"/> </label></td> <td><label> <input type="radio" name="q3" value="1"/> </label></td> </tr> <tr> <td colspan="3"> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td colspan="8"><strong>(5-Strongly Agree 50 %, 4 - Agree 60% , 3-Somewhat Agree 70 %, 2 -Disagree 80 % and 1-Strongly Disagree 90 %) </strong></td> </tr> <tr> <td colspan="3"> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td colspan="3">Q4. Does the employee require further training in this area? </td> <td><label> <input type="radio" name="q4" value="5"/> </label></td> <td><label> <input type="radio" name="q4" value="4"/> </label></td> <td><label> <input type="radio" name="q4" value="3"/> </label></td> <td><label> <input type="radio" name="q4" value="2"/> </label></td> <td><label> <input type="radio" name="q4" value="1"/> </label></td> </tr> <tr> <td colspan="3"> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td colspan="8"><blockquote> <blockquote> <blockquote> <blockquote> <blockquote> <blockquote> <blockquote> <blockquote> <blockquote> <blockquote> <p>Q5. Any other comments? </p> </blockquote> </blockquote> </blockquote> </blockquote> </blockquote> </blockquote> </blockquote> </blockquote> </blockquote> </blockquote></td> </tr> <tr> <td colspan="8"><label> <textarea name="anyc" cols="100" rows="20"></textarea> </label></td> </tr> <tr> <td colspan="8"> </td> </tr> <tr> <td colspan="2">Participant's Name : <label> <input type="pname"/> </label></td> <td>Employee ID: <label> <input type="emid"/> </label></td> <td>Ext : <label> <input type="ext"/> </label></td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td colspan="8">16</td> </tr> </table> <input name="submit" type="submit" value="Done" /> <input name="reset" type="reset" /> </form> </body> </html> i have made some change now its working but not properly kindly let me knw now where am making the mistake HTML: asp code HTML: value=
in which line am making the error because at my hand the head of the columns in server are correct but still it is not working
This says you are connecting to an Access database, not MySQL: set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open "c:/webdata/northwind.mdb" Code (markup): Change your provider and connection string to the proper settings, and go from there.
mySQL connection would be something like this: "Driver={MySQL ODBC 3.51 Driver};Server=xxx.xxx.xxx.xxx;Port=3306;Database=your_database_name;User=xxxxxx;Password=xxxxxx;Option=3;"