sqllllllll

sqllllllll

View Answers

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









Related Tutorials/Questions & Answers:
sqllllllll - Java Beginners
sqllllllll - Java Beginners
Advertisements

Ads