while (it.hasNext()) {
i++;
HashMap hm = (HashMap)it.next();
int ID = ((Long)hm.get("promotionid")).intValue();
IntMember promotionid = new IntMember("promotionid", ID, 10, "", 'T', false, 10);
StringMember title = new StringMember("title", (String)hm.get("title"), 10, "", 'T', true);
StringMember description = new StringMember("description", (String)hm.get("description"), 10,
"", 'T', false);
DateMember startdate = new DateMember("startdate", (java.util.Date)hm.get("startdate"), 10,
"URL", 'T', false, 100, "EST");
DateMember enddate = new DateMember("enddate", (java.util.Date)hm.get("enddate"), 10, "URL",
'T', false, 100, "EST");
StringMember status = new StringMember("status", (String)hm.get("status"), 10, "", 'T', false);
// int nooforder = ((Long)hm.get("nooforder")).intValue();
int nooforder = Integer.parseInt(hm.get("ordercount").toString());
IntMember nooforders = new IntMember("nooforders", nooforder, 10, "", 'T', false, 10);
PromotionListElement ele = new PromotionListElement(ID);
ele.put("promotionid", promotionid);
ele.put("title", title);