<%
    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());

%>