Project

<%
    String project<em>no=request.getParameter("project</em>no");
    String qry="select stud<em>name,project</em>name,project<em>type,project</em>no,receipt<em>no,receipt</em>fees,";
    qry+=" receipt<em>amt,receipt</em>tax,tot<em>weeks,to</em>char(receipt<em>dt,'dd/mm/yyyy') from proj</em>master ";
    qry+=" where project<em>no='"+project</em>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<em>mesg=err</em>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&gt;0)
    receipt_no1=receipt_no.substring(0,m);
if(m&gt;0 &amp;&amp; m1&gt;0)
    receipt_no2=receipt_no.substring(m+1,m1);
if(m1&gt;0 &amp;&amp; m2&gt;0)
    receipt_no3=receipt_no.substring(m1+1,m2);
if(m2&gt;0 &amp;&amp; m3&gt;0)
    receipt_no4=receipt_no.substring(m2+1,m3);
if(m3&gt;0 &amp;&amp; receipt_no.length()&gt;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&gt;0)
    receipt_fees1=receipt_fees.substring(0,c);
if(c&gt;0 &amp;&amp; c1&gt;0)
    receipt_fees2=receipt_fees.substring(c+1,c1);
if(c1&gt;0 &amp;&amp; c2&gt;0)
    receipt_fees3=receipt_fees.substring(c1+1,c2);
if(c2&gt;0 &amp;&amp; c3&gt;0)
    receipt_fees4=receipt_fees.substring(c2+1,c3);  
if(c3&gt;0 &amp;&amp; receipt_fees.length()&gt;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&gt;0)
    receipt_amt1=receipt_amt.substring(0,d);
if(d&gt;0 &amp;&amp; d1&gt;0)
    receipt_amt2=receipt_amt.substring(d+1,d1);
if(d1&gt;0 &amp;&amp; d2&gt;0)
    receipt_amt3=receipt_amt.substring(d1+1,d2);
if(d2&gt;0 &amp;&amp; d3&gt;0)
    receipt_amt4=receipt_amt.substring(d2+1,d3);
if(d3&gt;0 &amp;&amp; receipt_amt.length()&gt;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&gt;0)
    receipt_tax1=receipt_tax.substring(0,e);
if(e&gt;0 &amp;&amp; e1&gt;0)
    receipt_tax2=receipt_tax.substring(e+1,e1);
if(e1&gt;0 &amp;&amp; e2&gt;0)
    receipt_tax3=receipt_tax.substring(e1+1,e2);
if(e2&gt;0 &amp;&amp; e3&gt;0)
    receipt_tax4=receipt_tax.substring(e2+1,e3);
if(e3&gt;0 &amp;&amp; receipt_tax.length()&gt;0)
    receipt_tax5=receipt_tax.substring(e3+1,receipt_tax.length());

%>

January 19, 2011 at 11:42 AM

Hi Friend,

Please clarify your problem

Thanks