Jump to content

asp with MYSQL


Recommended Posts

  • 2 weeks later...
<!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><form method="post" action="demo_add.asp"><table><tr><td>CustomerID:</td><td><input name="custid"></td></tr><tr><td>Company Name:</td><td><input name="compname"></td></tr><tr><td>Contact Name:</td><td><input name="contname"></td></tr><tr><td>Address:</td><td><input name="address"></td></tr><tr><td>City:</td><td><input name="city"></td></tr><tr><td>Postal Code:</td><td><input name="postcode"></td></tr><tr><td>Country:</td><td><input name="country"></td></tr><tr>   <td>gender</td>   <td><label>	 <input type="radio" name="gender"  value="m" />   </label>	 <label>	 <input type="radio" name="gender"  value="f" />	 </label></td></tr></table><br /><br /><input type="submit" value="Add New"><input type="reset" value="Cancel"></form></body></html>____________________________________________________<%@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"%><%dim gendergender=Request.Form("gender")%><%sql="INSERT INTO customers (customerID,companyname,"sql=sql & "contactname,address,city,postalcode,country,gender)"sql=sql & " VALUES "sql=sql & "('" & Request.Form("custid") & "',"sql=sql & "'" & Request.Form("compname") & "',"sql=sql & "'" & Request.Form("contname") & "',"sql=sql & "'" & Request.Form("address") & "',"sql=sql & "'" & Request.Form("city") & "',"sql=sql & "'" & Request.Form("postcode") & "',"sql=sql & "'" & Request.Form("country") & "')"%><%if gender="m" %><%if gender="f" %><%if gender<>"" thensql=sql & "'" & Request.Form("gender") & "')"end if    on error resume nextconn.Execute sql,recaffectedif err<>0 then   Response.Write("No update permissions!")else   Response.Write("<h3>" & recaffected & " record added</h3>")end ifconn.close%></table></body></html>

Link to post
Share on other sites

What's the point of this: <%if gender="m" %><%if gender="f" %> You have 8 fields listed here: sql="INSERT INTO customers (customerID,companyname,"sql=sql & "contactname,address,city,postalcode,country,gender)" That means you need 8 values also. If you list the gender field, then you need a value for it. So you always need a value for gender, which means you should remove the if statement before you add gender and add it like any other field. You also have a closing parenthesis after the country value, that's an error.

Link to post
Share on other sites

thnx sir it worked out am working on a form and its related with above mention query plz guid me with the codes its creating error________________________________________________________________________________________

<!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="text" name="p_title" />    </label></td>    <td colspan="2">Date:	  <label>	  <input type="text" name="p_date" />	  </label></td>    <td colspan="2">Department:	  <input type="text" name="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="text" name="s_name" /></td>    <td colspan="2">Supervisor’s Email:	  <input type="text" name="s_email" /></td>    <td colspan="2">Supervisor’s Ext:</td>    <td colspan="2"><input type="text" name="s_ext" /></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="q1a5" />    </label></td>    <td width="74"><label>	  <input type="radio" name="q1a" value="q1a4" />    </label></td>    <td width="72"><label>	  <input type="radio" name="q1a" value="q1a3" />    </label></td>    <td width="65"><label>	  <input type="radio" name="q1a" value="q1a2" />    </label></td>    <td width="212"><label>	  <input type="radio" name="q1a" value="q1a1" />    </label></td>  </tr>  <tr>    <td colspan="3">Skills</td>    <td><label>	  <input type="radio" name="q1b"  value="q1b5" />    </label></td>    <td><label>	  <input type="radio" name="q1b" value="q1b4" />    </label></td>    <td><label>	  <input type="radio" name="q1b" value="q1b3" />    </label></td>    <td><label>	  <input type="radio" name="q1b" value="q1b2" />    </label></td>    <td><label>	  <input type="radio" name="q1b" value="q1b1" />    </label></td>  </tr>  <tr>    <td colspan="3">Attitude  </td>    <td><label>	  <input type="radio" name="q1c" value="q1c5" />    </label></td>    <td><label>	  <input type="radio" name="q1c" value="q1c4" />    </label></td>    <td><label>	  <input type="radio" name="q1c" value="q1c3" />    </label></td>    <td><label>	  <input type="radio" name="q1c" value="q1c2" />    </label></td>    <td><label>	  <input type="radio" name="q1c"  value="q1c1" />    </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="q25" />    </label></td>    <td><label>	  <input type="radio" name="q2" value="q24" />    </label></td>    <td><label>	  <input type="radio" name="q2" value="q23" />    </label></td>    <td><label>	  <input type="radio" name="q2" value="q22" />    </label></td>    <td><label>	  <input type="radio" name="q2" value="q21" />    </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="q35" />    </label></td>    <td><label>	  <input type="radio" name="q3" value="q34" />    </label></td>    <td><label>	  <input type="radio" name="q3" value="q33" />    </label></td>    <td><label>	  <input type="radio" name="q3" value="q32" />    </label></td>    <td><label>	  <input type="radio" name="q3" value="q31" />    </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="q45" />    </label></td>    <td><label>	  <input type="radio" name="q4" value="q44" />    </label></td>    <td><label>	  <input type="radio" name="q4" value="q43" />    </label></td>    <td><label>	  <input type="radio" name="q4" value="q42" />    </label></td>    <td><label>	  <input type="radio" name="q4" value="q41" />    </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="any_c" cols="100" rows="20"></textarea>    </label></td>  </tr>  <tr>    <td colspan="8"> </td>  </tr>  <tr>    <td colspan="2">Participant's Name :	  <label>	    <input type="text" name="p_name"/>    </label></td>    <td>Employee ID:	  <label>	    <input type="text" name="emid"/>    </label></td>    <td>Ext :	  <label>	    <input type="text" name="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>

__________________________________________________________________________________________________

<%@ Page Language="C#" ContentType="text/html" ResponseEncoding="utf-8" %><!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 (Programme Title,Date,"sql=sql & "Department,Supervisor’s Name,Supervisor’s Email,Supervisor’s Ext,Q1a,Q1b,Q1c,Q2,Q3,Q4,Q5,Participant's Name,Employee ID,Ext)"sql=sql & " VALUES "sql=sql & "('" & Request.Form("p_title") & "',"sql=sql & "'" & Request.Form("p_date") & "',"sql=sql & "'" & Request.Form("department") & "',"sql=sql & "'" & Request.Form("s_name") & "',"sql=sql & "'" & Request.Form("s_email") & "',"sql=sql & "'" & Request.Form("s_ext") & "',"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("any_c") & "',"sql=sql & "'" & Request.Form("p_name") & "',"sql=sql & "'" & Request.Form("emid") & "',"sql=sql & "'" & Request.Form("ext") & "')"    on error resume nextconn.Execute sql,recaffectedif err<>0 then   Response.Write("No update permissions!")else   Response.Write("<h3>" & recaffected & " record added</h3>")end ifconn.close%></body></html>

Link to post
Share on other sites

i have made some change now its working but not properly kindly let me knw now where am making the mistake____________________________________________________________________________________________________

<!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="p_title"/>    </label></td>    <td colspan="2">Date:	  <label>	  <input type="p_date" />	  </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="s_name" /></td>    <td colspan="2">Supervisor’s Email:	  <input type="s_email" /></td>    <td colspan="2">Supervisor’s Ext:</td>    <td colspan="2"><input type="s_ext" /></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="q1a5" />    </label></td>    <td width="74"><label>	  <input type="radio" name="q1a" value="q1a4" />    </label></td>    <td width="72"><label>	  <input type="radio" name="q1a" value="q1a3" />    </label></td>    <td width="65"><label>	  <input type="radio" name="q1a" value="q1a2" />    </label></td>    <td width="212"><label>	  <input type="radio" name="q1a" value="q1a1" />    </label></td>  </tr>  <tr>    <td colspan="3">Skills</td>    <td><label>	  <input type="radio" name="q1b"  value="q1b5" />    </label></td>    <td><label>	  <input type="radio" name="q1b" value="q1b4" />    </label></td>    <td><label>	  <input type="radio" name="q1b" value="q1b3" />    </label></td>    <td><label>	  <input type="radio" name="q1b" value="q1b2" />    </label></td>    <td><label>	  <input type="radio" name="q1b" value="q1b1" />    </label></td>  </tr>  <tr>    <td colspan="3">Attitude  </td>    <td><label>	  <input type="radio" name="q1c" value="q1c5" />    </label></td>    <td><label>	  <input type="radio" name="q1c" value="q1c4" />    </label></td>    <td><label>	  <input type="radio" name="q1c" value="q1c3" />    </label></td>    <td><label>	  <input type="radio" name="q1c" value="q1c2" />    </label></td>    <td><label>	  <input type="radio" name="q1c"  value="q1c1" />    </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="q25" />    </label></td>    <td><label>	  <input type="radio" name="q2" value="q24" />    </label></td>    <td><label>	  <input type="radio" name="q2" value="q23" />    </label></td>    <td><label>	  <input type="radio" name="q2" value="q22" />    </label></td>    <td><label>	  <input type="radio" name="q2" value="q21" />    </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="q35" />    </label></td>    <td><label>	  <input type="radio" name="q3" value="q34" />    </label></td>    <td><label>	  <input type="radio" name="q3" value="q33" />    </label></td>    <td><label>	  <input type="radio" name="q3" value="q32" />    </label></td>    <td><label>	  <input type="radio" name="q3" value="q31" />    </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="q45" />    </label></td>    <td><label>	  <input type="radio" name="q4" value="q44" />    </label></td>    <td><label>	  <input type="radio" name="q4" value="q43" />    </label></td>    <td><label>	  <input type="radio" name="q4" value="q42" />    </label></td>    <td><label>	  <input type="radio" name="q4" value="q41" />    </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="any_c" cols="100" rows="20"></textarea>    </label></td>  </tr>  <tr>    <td colspan="8"> </td>  </tr>  <tr>    <td colspan="2">Participant's Name :	  <label>	    <input type="p_name"/>    </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>_______________________________________________<%@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("p_title") & "',"sql=sql & "'" & Request.Form("p_date") & "',"sql=sql & "'" & Request.Form("department") & "',"sql=sql & "'" & Request.Form("s_name") & "',"sql=sql & "'" & Request.Form("s_email") & "',"sql=sql & "'" & Request.Form("s_ext") & "',"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("any_c") & "',"sql=sql & "'" & Request.Form("p_name") & "',"sql=sql & "'" & Request.Form("emid") & "',"sql=sql & "'" & Request.Form("ext") & "')"on error resume nextconn.Execute sql,recaffectedif err<>0 then   Response.Write("No update permissions!")else   Response.Write("<h3>" & recaffected & " record added</h3>")end ifconn.close%></body></html>

Link to post
Share on other sites

I don't know what "not working properly" means, you need to say what it is doing or not doing. If you're getting an error message then post the error message. And what's with all the blockquotes? Are you sure you have enough?

Link to post
Share on other sites

actually its generaing this error "No update permissions!" after making the changes in the code

<!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>___________________________________________________<%@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 nextconn.Execute sql,recaffectedif err<>0 then   Response.Write("No update permissions!")else   Response.Write("<h3>" & recaffected & " record added</h3>")end ifconn.close%></body></html>

Link to post
Share on other sites

Instead of this: if err<>0 thenResponse.Write("No update permissions!") since you don't really know that the error means that you don't have permission, it makes sense to print out the actual error. if err<>0 then Response.Write("Error code " & err)

Link to post
Share on other sites

If you search for that error code: http://www.google.co...iw=1538&bih=816 it looks like it means you don't have a valid SQL statement. You should print out the SQL statement after you build it to see what you're sending to the database. The problem might be that "date" is a reserved word in Access: http://support.microsoft.com/kb/286335 According to that article if you're using a reserved word as a name you need to surround it with square brackets. I thought you were trying to use MySQL though, not Access.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...