Help!

[preeti.kaushal@hotmail.com]

<%! String id,cgegis, itax, gpf_sub,hba_adv,hba_int,cpf_sub,pli,ic,it_scharge,afee,govt_cont,pm_relf,emp_tier_1;%>

<%Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbcdbcaydata1");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select EMP_TITLE,EMP_F_NAME,EMP_M_NAME,EMP_L_NAME,EMP_PF_ACCNO, EMP_Eid from EW_T_EMP where EMP_ECODE="+uname+"");
if(rs.next())
{
title=rs.getString("EMP_TITLE");
fname=rs.getString("EMP_F_NAME");
mname=rs.getString("EMP_M_NAME");
lname=rs.getString("EMP_L_NAME");
bkpuname1=rs.getInt("EMP_Eid");
}

if(mname==null)
{
mname="";
}
if(lname==null)
{
lname="";
}
stmt.close();
// want to convert it into array to store the entire tuples of database file EW_T_PBR

Statement stmt3=con.createStatement();
ResultSet rs3=stmt3.executeQuery("select * from EW_T_PBR_"+yr1+" where (PBR_EID="+bkpuname1+" AND PBR_MONTH='3' AND PBR_YEAR='"+yr2+"') ");
//want to access the 12 months records instead of specifying the one month record individually...
if(rs3.next())
{

cgegis=rs3.getString("PBR_CGEGIS"); //These are the attributes of the table.....
itax=rs3.getString("PBR_ITAX");
gpf_sub=rs3.getString("PBR_GPF_SUB");
hba_adv=rs3.getString("PBR_HBA_ADV");
hba_int=rs3.getString("PBR_HBA_INT");
cpf_sub=rs3.getString("PBR_CPF_SUB");
pli=rs3.getString("PBR_PLI");
lic=rs3.getString("PBR_LIC");
it_scharge=rs3.getString("PBR_IT_SCHARGE");
afee=rs3.getString("PBR_AFEE");
edu_cess=rs3.getString("PBR_EDU_CESS");
pm_relf=rs3.getString("PBR_PM_RELF");
govt_cont=rs3.getString("PBR_GOVT_CONT");
emp_tier_1=rs3.getString("PBR_EMP_TIER_1");

}
else
{
cgegis="0";
ita="0";
gpf_sub="0";
hba_adv="0";
hba_int="0";
cpf_sub="0";
pli="0";
lic="0";
it_scharge="0";
afee="0";
edu_cess="0";
pm_relf="0";
govt_cont="0";
emp_tier_1="0";
}
stmt3.close();
}

[postmortem]

spam, posting same garbage two times does not make it any better.

[Xeel]

Man, could you at least explain what the problem is.