Dear Sir,
I'm trying to update checkbox which is in string as Wend in asp programme. But I cannot update the Particular Coloumn name
I'm sending you the code. Please advice me that the person who logs in update the checkbox with his session name only whomsoever he thinks proper.
This Selection Procedure
Touranction.asp
<%@ Language=VBScript %>
<head>
<title>Zandu Pharmaceutical</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<%
Set Con = server.CreateObject ("ADODB.Connection")
Set Rs = server.CreateObject ("ADODB.Recordset")
Con.Open "FILEDSN=C:/odbc/zandu;UID=zandu;PWD=zandu12;DATABASE=Zandu;"
Rs.Open "Select distinct EMP_CODE From UserMaster",con
%>
<body bgcolor="#FFCCCC">
<form name="TourSanction" method="Post" action="TourSanctReport.asp">
<table width="100%" border="0">
<tr align="center" valign="top">
<td height="264">
<p> </p>
<p><font face="Trebuchet MS" color="#CCFFCC"><b><font color="#000000">Administrative
Form of Zandu Pharmaceutical</font></b></font></p>
<p><%=session("Name")%></p>
<table width="75%" border="0" height="121">
<tr bgcolor="#336699">
<td height="3" width="36%">
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#FFFFFF">Employee
Code</font></b></font></div>
</td>
<td height="3" width="27%">
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#FFFFFF">Month</font></b></font></div>
</td>
<td height="3" width="27%">
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#FFFFFF">Year</font></b></font></div>
</td>
</tr>
<tr bgcolor="#FFFFCC">
<td width="36%" height="30">
<div align="center">
<select name="emp">
<option value="Select" selected>Select</option>
<% While not Rs.EOF %>
<option value="<%=Rs(0).value%>"><%=Rs(0).value%></option>
<%Rs.Movenext%> <%Wend%>
</select>
</div>
</td>
<td width="27%" height="30">
<div align="center">
<select name="mon">
<option value="Select" selected>Select</option>
<option value="January">January</option>
<option value="February">February</option>
<option value="March">March</option>
<option value="April">April</option>
<option value="May">May</option>
<option value="June">June</option>
<option value="July">July</option>
<option value="August">August</option>
<option value="September">September</option>
<option value="October">October</option>
<option value="November">November</option>
<option value="December">December</option>
</select>
</div>
</td>
<td width="27%" height="30">
<div align="center">
<select name="period">
<option value="Select">Select</option>
<option value="2001" selected>2001</option>
<option value="2002">2002</option>
</select>
</div>
</td>
</tr>
<tr>
<td colspan="4" height="56">
<div align="center">
<input type="submit" name="Submit" value="Submit">
<a href="dbamenu.asp"><font color="#330099" face="Verdana, Arial, Helvetica, sans-serif"><b><font size="4">
</font></b></font></a></div>
</td>
</tr>
</table>
<p><a href="fomenu.asp"><font color="#330099" face="Verdana, Arial, Helvetica, sans-serif"><b><font size="4">EXIT</font></b></font></a></p>
</td>
</tr>
</table>
</form>
</body>
This is the selected page
TourSanctReport.asp
<head>
<Script>
function back() {
url="TourSanction.asp"
location.href = url;
}
</Script>
<title>Zandu Pharmaceutical</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<%
Set Con = Server.CreateObject ("ADODB.Connection")
Set Rs = Server.CreateObject ("ADODB.Recordset")
Con.Open "FILEDSN=C:/odbc/zandu;UID=zandu;PWD=zandu12;DATABASE=Zandu;"
Rs.Open "Select YEAR,State_Code,District,Head_Quarter,EMP_CODE,EMP_NAME,FOR_MONTH,DATE,WORK_PLACE,NIGHT_HALT,TRANSPORT_MODE,ADDRESS,DATE_OF_SUBMISSION,SANCTIONED_BY From TOUR_DETAIL where EMP_CODE='" & Request.Form ("emp") & "' and FOR_MONTH='" & Request.Form ("mon") & "' and YEAR = ' " & Request.Form ("period") & " '",Con
%>
<body bgcolor="#FFCCCC">
<form name="TourSanctReport" method="Post" action="sanctupinsert.asp">
<table width="100%" border="0">
<tr align="center" valign="top">
<td height="311"> <%if Rs.EOF then %>
<p align="left"><Label><font color="#FF0033"><b><font size="2" face="Trebuchet MS">Sorry!!!
there was no entries found for your request.</font></b></font></Label><% Else %></p>
<table width="100%" border="0">
<tr bgcolor="#336699">
<td colspan="22"><%=session("Name")%>
<input type="hidden" name="aname" value="<%=session("Name")%>">
<div align="center"><b><font color="#FFFFFF" size="2" face="Trebuchet MS">Feedback
for <%=Rs.Fields (5).Value %> of Employee Code No:<%=Rs.Fields (4).Value %>
</font><font size="2" face="Trebuchet MS"><b><font color="#990033">
<input type="hidden" name="code" value="<%=Rs(4).value%>">
</font></b></font> <font color="#FFFFFF" size="2" face="Trebuchet MS">For</font><font size="2" face="Trebuchet MS"><b><font size="2" face="Trebuchet MS"><b><font color="#990033">
</font><font size="2" face="Trebuchet MS"><b><font color="#990033"><%=Rs(6).value%></font></b></font><font color="#990033">
<input type="hidden" name="amonth" value="<%=Rs(6).value%>">
</font><font size="2" face="Trebuchet MS"><b><font color="#990033">
<%=Rs(0).value%></font></b></font><font color="#990033"> </font><font size="2" face="Trebuchet MS"><b><font color="#990033">
<input type="hidden" name="ayear" value="<%=Rs(0).value%>">
<input type="hidden" name="id" value="<%=Rs(13).value%>">
</font></b></font><font color="#990033"> </font></b></font></b></font><font size="2" face="Trebuchet MS"><b><font size="2" face="Trebuchet MS"><b><font color="#990033">
</font></b></font></b></font><font color="#FFFFFF" size="2" face="Trebuchet MS">
</font></b></div>
</td>
</tr>
<tr bgcolor="#336699">
<td width="3%">
<div align="center"><b><font color="#FFFFFF" size="2" face="Trebuchet MS">Year</font></b></div>
</td>
<td width="5%">
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#FFFFFF">Month</font></b></font></div>
</td>
<td width="3%">
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#FFFFFF">State
Code</font></b></font></div>
</td>
<td width="9%">
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#FFFFFF">District
Code</font></b></font></div>
</td>
<td width="3%">
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#FFFFFF">H.Q</font></b></font></div>
</td>
<td width="10%" colspan="2">
<div align="center"><font size="2" face="Trebuchet MS"><b></b></font></div>
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#FFFFFF">Emp.
Code</font></b></font></div>
</td>
<td width="4%">
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#FFFFFF">Name</font></b></font></div>
</td>
<td width="9%">
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#FFFFFF">Date</font></b></font></div>
</td>
<td width="3%">
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#FFFFFF">Filling
Date</font></b></font></div>
</td>
<td width="9%">
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#FFFFFF">Work
Place</font></b></font></div>
</td>
<td width="9%">
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#FFFFFF">Night
Halt </font></b></font></div>
</td>
<td width="6%">
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#FFFFFF">Transport
Mode</font></b></font></div>
</td>
<td width="8%">
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#FFFFFF">Contact
Add.</font></b></font></div>
</td>
<td width="8%">
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#FFFFFF">Sanction</font></b></font></div>
</td>
</tr>
<% While Not Rs.EOF %>
<tr bgcolor="#FFFFCC">
<td width="3%" height="25">
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#990033"><%=Rs(0).value%>
</font><font size="2" face="Trebuchet MS"><b><font color="#990033">
<input type="hidden" name="year">
</font></b></font><font color="#990033"> </font></b></font></div>
</td>
<td width="5%" height="25">
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#990033"><%=Rs(6).value%>
</font><font size="2" face="Trebuchet MS"><b><font color="#990033">
<input type="hidden" name="month">
</font></b></font><font color="#990033"> </font></b></font></div>
</td>
<td width="3%" height="25">
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#990033"><%=Rs(1).value%></font></b></font></div>
</td>
<td width="9%" height="25">
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#990033"><%=Rs(2).value%></font></b></font></div>
</td>
<td width="3%" height="25">
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#990033"><%=Rs(3).value%>
<input type="hidden" name="hq" value="<%=Rs(3).value%>">
</font></b></font></div>
</td>
<td width="10%" colspan="2" height="25">
<div align="center"><font size="2" face="Trebuchet MS"><b></b></font></div>
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#990033"><%=Rs(4).value%>
<input type="hidden" name="empcode">
</font></b></font></div>
</td>
<td width="4%" height="25">
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#990033"><%=Rs(5).value%></font></b></font></div>
</td>
<td width="9%" height="25">
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#990033"><%=Rs(7).value%>
</font></b></font></div>
</td>
<td width="3%" height="25">
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#990033"><%=Rs(12).value%></font><font size="2" face="Trebuchet MS"><b><font color="#990033">
<input type="hidden" name="dt">
</font></b></font></b></font></div>
</td>
<td width="9%" height="25">
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#990033"><%=Rs(8).value%></font></b></font></div>
</td>
<td width="9%" height="25">
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#990033"><%=Rs(9).value%></font></b></font></div>
</td>
<td width="6%" height="25">
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#990033"><%=Rs(10).value%>
<input type="hidden" name="tm" value="<%=Rs(10).value%>">
</font></b></font></div>
</td>
<td width="8%" height="25">
<div align="center"><font size="2" face="Trebuchet MS"><b><font color="#990033"><%=Rs(11).value%></font></b></font></div>
</td>
<td width="8%" height="25">
<div align="center"><font size="2" face="Trebuchet MS"><b>
<% Response.Write("<input type='checkbox' name='sanct'>")%>
<%Response.Write("<A href=sanctupinsert.asp.asp?I="&Server.URLEncode(Rs(12).Value)&">")%>
<br>
</b></font></div>
</td>
</tr>
<% Rs.MoveNext %> <% Wend %> <% End If %>
</table>
<table width="100%" border="0">
<tr align="center" valign="middle">
<td>
<input type="button" name="Button" value="OK!" onClick="return back()">
<input type="submit" name="Submit" value="Sanction">
</td>
</tr>
</table>
<p> </p>
<p> </p>
</td>
</tr>
</table>
</form>
</body>
This is the page which updates where I'm having Problem
sanctupinsert.asp
<%@ Language=VBScript %>
<%
Set Con = server.CreateObject("ADODB.Connection")
Con.Open "FILEDSN=C:/odbc/zandu;UID=zandu;PWD=zandu12;DATABASE=Zandu;"
for each i in Request.Form ("sanct")
MySQL = "Update TOUR_DETAIL set SANCTIONED_BY = ' " & Request.Form ("aname") & "' where EMP_CODE = '" & Request.Form ("code") & "' and FOR_MONTH = '" & Request.Form ("month") & "' and DATE_OF_SUBMISSION= '" & Request.Form ("dt") & "' and YEAR = '" & Request.Form ("year") & "' " & i
Con.Execute
next
Con.Close
Response.Redirect "TourSanction.asp"
%>
