ASP和JavaScript的信息提示一点儿也不工作

问题描述:

是我的代码任何人谁可以帮助我非常感谢ASP和JavaScript的信息提示一点儿也不工作

<% 
if request.form("Add") = " Add " then 

     if request.form("txtdistributor") = "" or request.form("sinumber") = "" or request.form("tstdate") = "" or request.form("drnumber") = "" or request.form("drdate") = "" or request.form("receivedby") = "" then 
     response.redirect("salesinvoice.asp?userloggedin=" &request.querystring("userloggedin") &"&dist=" &request.QueryString("dist")) 
     end if 


      SQLString = "INSERT INTO salesinvoice (distributor,sidate,sinumber) VALUES ('" & Request.form("txtdistributor") & "','" & Request.Form("tstdate") & "','" & Request.Form("sinumber") &"') " 

      set DBConn = Server.CreateObject("ADODB.Connection") 
      DBConn.Open Application("dals_ConnectionString") 

      DBConn.Execute(SQLString) 
      DBConn.Close 


      set DBConn = Server.CreateObject("ADODB.Connection") 
      DBConn.Open Application("dals_ConnectionString") 
      SQLString = "INSERT INTO Delivery_Receipt (Date_Purchase, Receipt_no, Distributor, Received_by, Entry_Date,sinumber) VALUES" 
      SQLString = SQLString & "('" & Request.Form("drdate") & "','" & Request.Form("drnumber") & "', '" & Request.Form("txtdistributor")& "','" & Request.Form("receivedby") & "','" & now() & "','" & request.Form("sinumber") & "')" 

      DBConn.Execute(SQLString) 
      DBConn.Close 



response.Redirect("salesinvoice.asp?userloggedin=" &request.QueryString("userloggedin") &"&dist=" &request.QueryString("dist")) 

end if 
%> 


<!-- Javascript --> 
<script type="text/javascript"> 

function validateform() 
{ 
    if (document.frm.txtdistributor.value == '') 
    { 
    alert('Please input distributor'); 
    document.frm.txtdistributor.focus(); 
    return false; 
    } 
    if (document.frm.txtdistributor.value == '') 
    { 
    alert('Please input distributor'); 
    document.frm.txtdistributor.focus(); 
    return false; 
    } 
    if (document.frm.sinumber.value == '') 
    { 
    alert('Please input sales invoice number'); 
    document.frm.sinumber.focus(); 
    return false; 
    } 
    if (document.frm.tstdate.value == '') 
    { 
    alert('Please input sales invoice date'); 
    document.frm.tstdate.focus(); 
    return false; 
    } 
    if (document.frm.drnumber.value == '') 
    { 
    alert('Please input Delivery Receipt Number'); 
    document.frm.drnumber.focus(); 
    return false; 
    } 
    if (document.frm.drdate.value == '') 
    { 
    alert('Please input Delivery Receipt'); 
    document.frm.drdate.focus(); 
    return false; 
    } 
    if (document.frm.receivedby.value == '') 
    { 
    alert('Please input requestor'); 
    document.frm.receivedby.focus(); 
    return false; 
    } 
return true; 
} 
</script> 
<html> 
    <head> 
     <title>Sales Invoice</title> 
    </head> 
<body> 

<!--#include file="header.asp"--> 
<form name="frm" id="frm" action="salesinvoice.asp?userloggedin=<%=request.QueryString("userloggedin")%>&dist=<%=request.QueryString("dist")%>" method="post" onSubmit="return validateform();"> 

<link href="css/calendar.css" rel="stylesheet" type="text/css"> 
<script type="text/javascript" src="calendar_date_picker.js"></script> 
<script type="text/javascript"> 
var cdp1 = new CalendarDatePicker(); 
var props = { 
    debug :   true, 
    excludeDays :  [6,0,1], 
    excludeDates :  ['20081225','20081226','20091225','20091226'], 
    minimumFutureDate : 5, 
    formatDate :  '%m-%d-%y' 
    }; 
var cdp2 = new CalendarDatePicker(props); 
props.formatDate = '%d-%m-%y'; 
var cdp3 = new CalendarDatePicker(props); 
cdp3.endYear = cdp3.startYear + 1; 
</script> 

<table width="900" align="center"> 
    <tr> 
     <td width="200">Distributor</td> 
     <td> 

    <%if request.querystring("dist") <> "yes" then%> 

     <select name="txtdistributor" style="width:260;"> 
     <option value="">- Select -</option> 
     <% 
      strsql = "select Distinct(Distributor) from salesinvoice" 
      set rsdist = server.createobject("adodb.recordset") 
      rsdist.open strsql,application("dals_connectionstring") 

      while not rsdist.eof 
     %> 

      <option value="<%=rsdist("distributor")%>"><%=rsdist("distributor")%></option> 

     <% 
     rsdist.movenext 
     wend 

     rsdist.close 
     set rsdist = nothing 
     %> 
    </select>&nbsp;<a href="salesinvoice.asp?UserLoggedIn=<%=request.QueryString("UserLoggedIn")%>&dist=yes">Add New Distributor</a> 
    <%end if%> 

    <%if request.querystring("dist") <> "no" then%> 
     <input type="text" size="38" name="txtdistributor" id="txtdistributor">&nbsp;<a href="salesinvoice.asp?UserLoggedIn=<%=request.QueryString("UserLoggedIn")%>&dist=no">[ - ]</a> 
    <%end if%> 

     </td> 
    </tr> 
    <tr> 
     <td>SI Number</td> 
     <td><input type="text" name="sinumber" id="sinumber"></td> 
    </tr> 
    <tr> 
     <td>SI Date</td> 
     <td><input type="text" name="tstdate" id="txtdate" readonly>&nbsp;<a href="#" onClick="cdp1.showCalendar(this, 'txtdate'); return false;"><img src="images/calendar.png" border="0" align="absmiddle" style="cursor:hand;" title="Calendar"></a></td> 
    </tr> 
    <tr> 
     <td>DR Number</td> 
     <td><input type="text" name="drnumber" id="drnumber"></td> 
    </tr> 
    <tr> 
     <td>DR date</td> 
     <td><input type="text" name="drdate" id="drdate" readonly>&nbsp;<a href="#" onClick="cdp1.showCalendar(this, 'drdate'); return false;"><img src="images/calendar.png" border="0" align="absmiddle" style="cursor:hand;" title="Calendar"></a></td> 
    </tr> 
    <tr> 
     <td>Received by</td> 
     <td> 
     <!--<input type="text" name="receivedby" id="receivedby">--> 
     <select name="receivedby" id="receivedby"> 
      <option value="">- Select -</option> 
      <% 
      strsql = "select first_name,last_name from sysadusers" 
      set rsname = server.CreateObject("adodb.recordset") 
      rsname.open strsql,application("dals_connectionstring") 

      while not rsname.eof 
      %> 
       <option value="<%=rsname("first_name")%>, <%=rsname("last_name")%>"><%=rsname("first_name")%>, <%=rsname("last_name")%></option> 
      <% 
      rsname.movenext 
      wend 

      rsname.close 
      %> 

     </select> 
+0

SQL注入攻击,有人吗? – 2011-06-09 01:58:58

+0

你可以教我多谢先生 – user772304 2011-06-09 02:47:31

+0

@ Phil.Wheeler在这种情况下是单独的问题,这里的问题在脚本 – AjayR 2011-06-09 03:15:35

我没有看到你关闭表单并提交按钮。 如果一切正常,最好建议您发布HTML生成的代码或调试萤火虫等。 您可以在validateform函数中放置断点以了解错误。

请尝试document.getElementById。

+0

同样的结果我把标签并没有发生 – user772304 2011-06-09 02:23:25

+0

你看到任何JavaScript错误吗?,你有萤火虫安装在Firefox中,并检查 – AjayR 2011-06-09 02:30:58

+0

好的,谢谢我会尝试着火bug – user772304 2011-06-09 02:35:54

验证函数中可能存在运行时错误,例如,当表单不包含txtdistributor下拉列表时。

为了调试的目的,功能改变这只是:

function validateform() { 
    alert("validation started"); 
    var oDDL = document.frm.txtdistributor; 
    if (oDDL) { 
     if (oDDL.value == '') { 
     alert('Please input distributor'); 
     oDDL.focus(); 
     } 
    } else { 
     alert("form does not contain txtdistributor"); 
    } 
    alert("validation ended"); 

    return false; 
} 

如果一切正常,应用相同的逻辑领域的休息和删除调试信息。