salman.pirani
-
Posts
83 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by salman.pirani
-
-
whts is this about
-
now it is giving this Error code -2147217900
-
can u plz specify what code should i use to show the error
-
but am not getting the reply plz help me
-
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> -
plz specifiy wher am creating mistake
-
need ur help _____________________________________________________________________
<!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> -
really need ur help
-
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> -
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> -
above are the codes which am using, kindly confirm where am making mistakes. thanks
-
<!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> -
how can i insert the data in sql database via radio button in asp
-
thanks for the link but this is only showing the how to connect with data base but if i want to send any value to a specific column in mysql via asp so wht would be the code. thanks
-
how can i connect asp with mysqlfor example if i want to send first name and last name into the columns of mysql so what will be the code . thanks
-
oh thanks for help now its uploading the file to the server but if its not uploading a zip file how can i make the changes in the code so that i can upload a zip or rar file to server i have tried some changes but its not working.thanks
-
oh thanks for help now its uploading the file to the server but if its not uploading a zip file how can i make the changes in the code so that i can upload a zip or rar file to server i have tried some changes but its not working. thanks
-
is this the correct code
-
plz reply
-
thnx alot its working
-
oh now i got this ...but its still not giving the resultits generation this error___________________________________Upload: Chrysanthemum1.jpgType: image/jpegSize: 12.080078125 KbTemp file: C:\wamp\tmp\php5CAC.tmpWarning: move_uploaded_file(upload/Chrysanthemum1.jpg) [function.move-uploaded-file]: failed to open stream: No such file or directory in C:\wamp\www\forum\upload_file.php on line 36Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to move 'C:\wamp\tmp\php5CAC.tmp' to 'upload/Chrysanthemum1.jpg' in C:\wamp\www\forum\upload_file.php on line 36Stored in: upload/Chrysanthemum1.jpg
-
error Parse error: parse error in C:\wamp\www\forum\upload_file.php on line 17
-
this is the code____________<?php$allowedExts = array("jpg", "jpeg", "gif", "png");$chunks = explode(".", $_FILES["file"]["name"]);$extension = end($chunks);if (($_FILES["file"]["type"] == "image/gif"|| $_FILES["file"]["type"] == "image/jpeg"|| $_FILES["file"]["type"] == "image/pjpeg")&& $_FILES["file"]["size"] < 20000&& in_array($extension, $allowedExts))if ($_FILES["file"]["error"] > 0)(echo "Return Code: " . $_FILES["file"]["error"] . "<br />";)else(echo "Upload: " . $_FILES["file"]["name"] . "<br />";echo "Type: " . $_FILES["file"]["type"] . "<br />";echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";)if (file_exists("upload/" . $_FILES["file"]["name"]))(echo $_FILES["file"]["name"] . " already exists. ";)else(move_uploaded_file($_FILES["file"]["tmp_name"],"upload/" . $_FILES["file"]["name"]);echo "Stored in: " . "upload/" . $_FILES["file"]["name"]
))else(echo "Invalid file"?> -
am getting error in this code plz help me error : Parse error: parse error in C:\wamp\www\upload\upload_file.php on line 45 code: <?php$allowedExts = array("jpg", "jpeg", "gif", "png");$chunks = explode(".", $_FILES["file"]["name"]);$extension = end($chunks);if (($_FILES["file"]["type"] == "image/gif"|| $_FILES["file"]["type"] == "image/jpeg"|| $_FILES["file"]["type"] == "image/pjpeg")&& $_FILES["file"]["size"] < 20000&& in_array($extension, $allowedExts))if ($_FILES["file"]["error"] > 0){echo "Return Code: " . $_FILES["file"]["error"] . "<br />";}else{echo "Upload: " . $_FILES["file"]["name"] . "<br />";echo "Type: " . $_FILES["file"]["type"] . "<br />";echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";}if (file_exists("upload/" . $_FILES["file"]["name"])){echo $_FILES["file"]["name"] . " already exists. ";}else{move_uploaded_file($_FILES["file"]["tmp_name"],"upload/" . $_FILES["file"]["name"]);echo "Stored in: " . "upload/" . $_FILES["file"]["name"];}}}else{echo "Invalid file";}?>
))else(echo "Invalid file"
asp with MYSQL
in ASP
Posted
am using acces as mention in w3 school tuto so sould i chnage the name date ? or wht should i do now