");
for (int j = 0; j < v_cats.size(); j++)
{db_cats = (String)v_cats.elementAt(j);
if (db_cats!=null)
{out.println(""+db_cats+", ");}//end if
}//end for
out.println("
");
///////////////////////////////////////////////////////
// within this block we will make several database //
// connections to retreive the values according //
// to the matching values named as db_cats //
///////////////////////////////////////////////////////
conn = cn();
stat = conn.createStatement();
out.println(" ");
if (v_cats.isEmpty()) out.println("v_cats.isEmpty()"+v_cats+" ");
for (int j = 0; j < v_cats.size(); j++)
{db_cats = (String)v_cats.elementAt(j);
if (db_cats!=null)
{
chSQL="select * from bizz_links where link_category ='"+db_cats+"'";
//out.println(j+" "+db_cats+" ");
//out.println(chSQL+" ");
out.println(""+db_cats+" ::.
");
}//end while
if ( rs_2 != null ) rs_2.close();
}//end try
catch(java.sql.SQLException e) {
smessagesErr = e.toString();
out.println(smessagesErr);
//response.sendRedirect("links.jsp?message=Links Could not be loaded successfully,please try again later"+smessagesErr);
}
out.println("
");
}//end if
}//end for
try{
if ( stat != null ) {stat.close();}
if ( conn != null ) {conn.close();}
}
catch(Exception e) {
smessagesErr = e.toString();
out.println(smessagesErr);
//response.sendRedirect("links.jsp?message=Links Could not be loaded successfully,please try again later"+smessagesErr);
}
////////////////////////////////////////////////////////
%>