October 15, 2008 at 6:37 PM
could u provide query below format
insert into table1 (col1,col2,col3) values('aa',todate(req.getParameter("bb")....,todate(............));
one thing replacestr is it any method or function avail in sql
clarify it. then i give solu with in 5 min
October 15, 2008 at 6:51 PM
what is use of g clarify it?
October 15, 2008 at 7:00 PM
Hi
Use this might be work, if not just clarify about the replacestr what it does?
other wise try to modify
String st = "insert into ConDetailspopup (FORMID,NAMEOFCONT," +
"NUMOFCONLABENG,CONPERFORMDATE,CONTPERTODATE,PONUM,VALUE,ESI,EPF) " +
"values('" + FORMID.trim() + "', replacestr('"+ request.getParameter("txtNAMEOFCONT")+"'," + g +")," +
"to_Number('"+ request.getParameter("txtNUMOFCONLABENG")+"'," + g +")," +
"to_date('"+request.getParameter("txtCONPERFORMDATE") +"','dd-mm-yyyy')," +
"to_date('"+request.getParameter("txtCONPERTODATE") + "','dd-mm-yyyy')," +
"replacestr('" + request.getParameter("txtPONUM")+ "'," + g +")," +
"to_Number('" + request.getParameter("txtVALUE")+"'," + g +")," +
"replacestr('"+ request.getParameter("txtESI") +"'," + g +"),"+
"replacestr('" + request.getParameter("txtEPF")+"'," + g +"))";
Rajanikant