<% String project no=request.getParameter("project no"); String qry="select stud name,project name,project type,project no,receipt no,receipt fees,"; qry+=" receipt amt,receipt tax,tot weeks,to char(receipt dt,'dd/mm/yyyy') from proj master "; qry+=" where project no='"+project no+"'"; Vector vcol=new Vector(); Vector vdata=new Vector(); String mess =hrm.getData(stmt,qry,1,0,vcol,vdata); String err_mesg=hrm.getErr(); err mesg=err mesg+" "+qry; int nr=hrm.getRows(vdata); int nc=hrm.getCols(vdata); hrm.close(); String stud_name=(String) vdata.get(1); String project_name=(String) vdata.get(2); String project_type=(String) vdata.get(3); String receipt_no=(String) vdata.get(4); String receipt_fees=(String) vdata.get(5); String receipt_amt=(String) vdata.get(6); String receipt_tax=(String) vdata.get(7); String tot_weeks=(String) vdata.get(8); String receipt_dt=(String) vdata.get(9); int n =stud_name.indexOf(','); int n1 =stud_name.indexOf(',',n+1); int n2 =stud_name.indexOf(',',n1+1); int n3 =stud_name.indexOf(',',n2+1); String stud_name1=stud_name.substring(0,n); String stud_name2=stud_name.substring(n+1,n1); String stud_name3=stud_name.substring(n1+1,n2); String stud_name4=stud_name.substring(n2+1,n3); String stud_name5=stud_name.substring(n3+1,stud_name.length()); String receipt_no1="",receipt_no2="",receipt_no3="",receipt_no4="",receipt_no5=""; int m =receipt_no.indexOf(','); int m1 =receipt_no.indexOf(',',m+1); int m2 =receipt_no.indexOf(',',m1+1); int m3 =receipt_no.indexOf(',',m2+1); if(m>0) receipt_no1=receipt_no.substring(0,m); if(m>0 && m1>0) receipt_no2=receipt_no.substring(m+1,m1); if(m1>0 && m2>0) receipt_no3=receipt_no.substring(m1+1,m2); if(m2>0 && m3>0) receipt_no4=receipt_no.substring(m2+1,m3); if(m3>0 && receipt_no.length()>0) receipt_no5=receipt_no.substring(m3+1,receipt_no.length()); String receipt_fees1="",receipt_fees2="",receipt_fees3="",receipt_fees4="",receipt_fees5=""; int c =receipt_fees.indexOf(','); int c1 =receipt_fees.indexOf(',',c+1); int c2 =receipt_fees.indexOf(',',c1+1); int c3 =receipt_fees.indexOf(',',c2+1); if(c>0) receipt_fees1=receipt_fees.substring(0,c); if(c>0 && c1>0) receipt_fees2=receipt_fees.substring(c+1,c1); if(c1>0 && c2>0) receipt_fees3=receipt_fees.substring(c1+1,c2); if(c2>0 && c3>0) receipt_fees4=receipt_fees.substring(c2+1,c3); if(c3>0 && receipt_fees.length()>0) receipt_fees5=receipt_fees.substring(c3+1,receipt_fees.length()); String receipt_amt1="",receipt_amt2="",receipt_amt3="",receipt_amt4="",receipt_amt5=""; int d =receipt_amt.indexOf(','); int d1 =receipt_amt.indexOf(',',d+1); int d2 =receipt_amt.indexOf(',',d1+1); int d3 =receipt_amt.indexOf(',',d2+1); if(d>0) receipt_amt1=receipt_amt.substring(0,d); if(d>0 && d1>0) receipt_amt2=receipt_amt.substring(d+1,d1); if(d1>0 && d2>0) receipt_amt3=receipt_amt.substring(d1+1,d2); if(d2>0 && d3>0) receipt_amt4=receipt_amt.substring(d2+1,d3); if(d3>0 && receipt_amt.length()>0) receipt_amt5=receipt_amt.substring(d3+1,receipt_amt.length()); String receipt_tax1="",receipt_tax2="",receipt_tax3="",receipt_tax4="",receipt_tax5=""; int e =receipt_tax.indexOf(','); int e1 =receipt_tax.indexOf(',',e+1); int e2 =receipt_tax.indexOf(',',e1+1); int e3 =receipt_tax.indexOf(',',e2+1); if(e>0) receipt_tax1=receipt_tax.substring(0,e); if(e>0 && e1>0) receipt_tax2=receipt_tax.substring(e+1,e1); if(e1>0 && e2>0) receipt_tax3=receipt_tax.substring(e1+1,e2); if(e2>0 && e3>0) receipt_tax4=receipt_tax.substring(e2+1,e3); if(e3>0 && receipt_tax.length()>0) receipt_tax5=receipt_tax.substring(e3+1,receipt_tax.length()); %>
Hi Friend,
Please clarify your problem
Thanks
Ads