PREVIOUS CURRENCY EXCHANGE

// // (1) check what is number of COLSPAN ? // sqlStr = "SELECT f_date, COUNT(f_time) AS expr_cnt_f_time FROM exchange_rate_head " + "GROUP BY f_date " + "ORDER BY f_date DESC"; cursor = database.cursor (sqlStr); i = 0; max_time = 0; while (cursor.next()) { i++; if (i > 7) break; if (max_time < cursor.expr_cnt_f_time) max_time = cursor.expr_cnt_f_time; } if (i > 0) {

write (" // // (2) display Detail of Table : EXCHANGE_RATE_HEAD // sqlStr = " SELECT * FROM exchange_rate_head " + " ORDER BY f_date DESC, f_time ASC "; cursor = database.cursor (sqlStr); flg_first = true; w_date = ""; cnt_day = 0; w_numcol = 1; while (cursor.next()) { w_yyyy = cursor.f_date.substring(0,4); w_mm = cursor.f_date.substring(4,6); w_dd = cursor.f_date.substring(6,8); w_link_rate = ""; if (w_date != cursor.f_date) { cnt_day++; if (cnt_day > 7) break; if (!flg_first) { for (i=w_numcol; i \n"); write ("\n"); } write ("\n"); write ("\n"); write ("\n"); w_date = cursor.f_date; flg_first = false; w_numcol=1; } else { write ("\n"); w_numcol++; } // = f_date } // next for (i=w_numcol; i \n");
Date "); Time
  ", ymd2date_str(cursor.f_date), "    ", w_link_rate, hhmm2time_str(cursor.f_time), "", "    ", w_link_rate, hhmm2time_str(cursor.f_time), "", "  
} // if i > 0 // else {
Sorry, data not available.
} // if..i==0


designed by scit