<%
boolean FLAG_exst = false;
int oldValue =0;
int newValue = 0;
int totSubCat =0;
rSet = stmt.executeQuery("SELECT CSCat_Id FROM cardmaster WHERE CMCat_Id ="+CMCat_Id);
if (rSet != null) {
while (rSet.next()) {
FLAG_exst = true;
newValue = rSet.getInt ("CSCat_Id");
if (newValue != oldValue ){
totSubCat++;
oldValue = newValue;
}//End of IF newValue
} // end of While rSet
} // End of If rSet
if (totSubCat==0 && FLAG_exst==false ){
%>
Sorry!
We have no collection regarding your choice, We are continue to update our
cards collection. You can check us later on. To check Other collection click
below.
<%
} else {
strArr = new String[6][3];
intArr = new int[6][2];
rSet = stmt.executeQuery("SELECT * FROM cardmaster WHERE CMCat_Id ="+CMCat_Id+" AND Card_Priority='M'");
if (rSet != null) {
counter =0;
while (rSet.next()) {
strArr[counter][0] = rSet.getString("Card_Icon");
strArr[counter][1] = rSet.getString("CTitle");
strArr[counter][2] = rSet.getString("Card_Desrp");
intArr[counter][0] = rSet.getInt("CMCat_Id");
intArr[counter][1] = rSet.getInt("CSCat_Id");
counter++;
} //End of while rSet
} //End of if rSet
%>
