Date picker is not work

gunjan

Hi sumitra, when i save my form it show error
my script is


function towerform($companyname,$password,$taxid,$fname,$lname,$phone1,$phone2,$email,$add,$zip,$status,$createdby,$closedate,$closewonby,$insexpdate)
{
_setValue(_textbox("txtCompanyName"), $companyname);
_setValue(_textbox("txtPassword"), $password);


_setValue(_textbox("txtFederalTaxID"), $taxid);


_setValue(_textbox("txtFirstName"), $fname);
_setValue(_textbox("txtLastName"), $lname);
_setValue(_textbox("txtPhone1Code"), $phone1);
_setValue(_textbox("txtPhone1"), $phone2);
_setValue(_textbox("txtEmail"), $email);
_setValue(_textbox("txtAdd1"), $add);
_setValue(_textbox("lstZipCode"), $zip);
_setSelected(_select("Status"), $status);
_setSelected(_select("txtCreatedBy"), $createdby);
_wait(15000,_exists(elememt));
_setValue(_textbox("txtCloseDate"), $closedate);


_wait(15000,_exists(elememt));
_setSelected(_select("txtCloseWonBy"), $closewonby);
_wait(10000,_exists(elememt));
_setValue(_textbox("InsExpDate"), $insexpdate);
_wait(10000,_exists(elememt));
//_click(_checkbox("SameAs"));
//_click(_submit("Save"));
//_wait(10000,_exists(elememt));


}
// Get the DB instance
var db = _getDB("sun.jdbc.odbc.JdbcOdbcDriver", "jdbc:odbc:Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)}; DBQ=C:\\Test Data\\Book13.xls;readOnly=false", "", "");

$rs = db.select("select * from [Sheet1$]");

for(var $i=0; $i<$rs.length; $i++)
{
towerform($rs[$i]["txtCompanyName"], $rs[$i]["txtPassword"],$rs[$i]["txtFederalTaxID"], $rs[$i]["txtFirstName"], $rs[$i]["txtLastName"],$rs[$i]["txtPhone1Code"],$rs[$i]["txtPhone1"],$rs[$i]["txtEmail"], $rs[$i]["txtAdd1"],""+parseInt($rs[$i]["lstZipCode"]),$rs[$i]["Status"], $rs[$i]["txtCreatedBy"],$rs[$i]["txtCloseDate"],$rs[$i]["txtCloseWonBy"],$rs[$i]["InsExpDate"]);
_click(_checkbox("SameAs"));
//_wait(15000,_exists(elememt));
_click(_submit("Save"));
//_wait(15000,_exists(elememt));
}




And error is

Starting script
_setValue(_textbox("txtCompanyName"), "American EX"); at Nov 8, 2011 5:13:54 PM
_setValue(_textbox("txtPassword"), "12ab34cd"); at Nov 8, 2011 5:13:54 PM
_setValue(_textbox("txtFederalTaxID"), "123456789101112"); at Nov 8, 2011 5:13:55 PM
_setValue(_textbox("txtFirstName"), "dipti"); at Nov 8, 2011 5:13:55 PM
_setValue(_textbox("txtLastName"), "shah"); at Nov 8, 2011 5:13:55 PM
_setValue(_textbox("txtPhone1Code"), "789.0"); at Nov 8, 2011 5:13:55 PM
_setValue(_textbox("txtPhone1"), "567-9876"); at Nov 8, 2011 5:13:55 PM
_setValue(_textbox("txtEmail"), "d@s.com"); at Nov 8, 2011 5:13:55 PM
_setValue(_textbox("txtAdd1"), "abcd1"); at Nov 8, 2011 5:13:55 PM
_setValue(_textbox("lstZipCode"), "78727"); at Nov 8, 2011 5:13:56 PM
_setSelected(_select("Status"), "Past due"); at Nov 8, 2011 5:13:56 PM
_setSelected(_select("txtCreatedBy"), "RJB"); at Nov 8, 2011 5:13:56 PM
_wait(15000, "_exists(elememt)"); at Nov 8, 2011 5:14:11 PM
_setValue(_textbox("txtCloseDate"), "7/8/2010"); at Nov 8, 2011 5:14:11 PM
_wait(15000, "_exists(elememt)"); at Nov 8, 2011 5:14:26 PM
_setSelected(_select("txtCloseWonBy"), "RJB"); at Nov 8, 2011 5:14:26 PM
_wait(10000, "_exists(elememt)"); at Nov 8, 2011 5:14:36 PM
_setValue(_textbox("InsExpDate"), "11/6/2012"); at Nov 8, 2011 5:14:36 PM
_wait(10000, "_exists(elememt)"); at Nov 8, 2011 5:14:46 PM
_click(_checkbox("SameAs")); at Nov 8, 2011 5:14:46 PM
_click(_submit("Save"));
Error: The parameter passed to _click was not found on the browser at Nov 8, 2011 5:15:00 PM
Stopping script



can u plz help me how to solve it?




Thanks,
Gunjan.

Sumitra

Hi Gunjan,

Can you Ctrl+Hover on the Save button >> perform click on it and check if you are getting any error on controller.

Also, try using:

_wait(100000,_submit("Save")); and check if it works.

Regards
Sumitra