passing parameters to delete the records in databa
Hello Guys, I am trying to pass parameters which are in array and
the values are not passed. Can you help me please, The values I try to pass are txtdateFrom,txtdateUntil, txtHourlyRate. I try to pass
in the function Confirm delete. Then I try to see whether the values are passed or not. They are not pass. Please help me and modify the code.
Do while not objHistoryRate.EOF
dateFrom =cstr(convNull (objHistoryRate("dtRateFrom")))
dateUntil=cstr(convNull (objHistoryRate("dtRateTo")))
HourlyRate=cstr(convNull(objHistoryRate("decHourly Rate")))
strGrid =strGrid+ " <TD><INPUT type=""text"" size=15 id=txtdateFrom name=txtdateFrom value='"+ dateFrom +" '></TD>"
strGrid =strGrid+ " <TD><INPUT type=""text"" size=15 id=txtdateUntil name=txtdateUntil value='"+ dateUntil+" '></TD>"
strGrid =strGrid+ " <TD><INPUT type=""text"" size=15 id=txtHourlyRate name=txtHourlyRate value='"+HourlyRate+" '></TD>"
strGrid =strGrid+ " <TD ><img type =""button"" name=btnDelete src ='images/xDel1.gif' onclick=""javascript:deleteConfirm(txtdateFrom,txt dateUntil,txtHourlyRate);""></TD></TR>"
'Response.Write("<br>loop" +cstr(index)+"</br>")
objHistoryRate.MoveNext()
loop
end if
strGrid = strGrid + "</Tr></TABLE>"
Response.Write(strGrid)
<script language = javascript>
function deleteConfirm(txtdateFrom,txtdateUntil,txtHourlyRa te) {
var Msg="DO you want to Delete the record";
if (confirm(Msg)){
dateFrom1=document.thisForm.txtdateFrom.value;
dateUntil2=document.thisForm.txtdateUntil.value;
HourlyRate3=document.thisForm.txtHourlyRate.value;
document.thisForm.submit();
return true; }
else {
alert("Record not deleted")
return false;}
if Request.Form("txtMode")="R" then
strDel = "delete * from tblCustRate" &_
"where iEmpID =" & iEmpID &_
"and iTaskiD=" & iTaskID&_
"and iProjDetiD=" & iProjDetID&_
" and dtRateFrom=" &dateFrom1&_
" and dtRateTo=" &dateUntil2&_
" and decHourlyRate=" &HourlyRate3
set rsStrDelete =server.CreateObject("ADODB.Recordset")
rsStrDelete.ActiveConnection = objConn
Response.Write strDel
|