Latest Tutorials| Questions and Answers|Ask Questions?|Site Map




Have Programming Question? Ask it here!
 
 
 


Ragini Shukla
sqllllllll
3 Answer(s)      5 years and 10 months ago
Posted in : Java Beginners



Advertisement
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:
Advertisements
 

 

 

DMCA.com