// 'ta', // tamil
// '**', // other
),
- 'c' => array(
- 'AU', 'CN', 'HK', 'IN', 'ID', 'JP', 'MY', 'NZ', 'TW', 'SG', 'TH', 'KR', 'US', 'PH', 'VN','**'
- ),
+ 'c' => '*', // array(
+ //'AU', 'CN', 'HK', 'IN', 'ID', 'JP', 'MY', 'NZ', 'TW', 'SG', 'TH', 'KR', 'US', 'PH', 'VN','**'
+ //),
'm' => array(
'USD', 'HKD', 'GBP', 'CNY', 'SGD', 'JPY'
),
}
if (!empty($q['query']['name'])) {
//DB_DAtaObject::debugLevel(1);
-
- $this->whereAdd("lval LIKE '". $this->escape($q['query']['name']). "%'");
+ $v = strtoupper($this->escape($q['query']['name']));
+ $this->whereAdd("upper(lval) LIKE '%{$v}%'");
}
if (!empty($q['_filtered']) && !empty($this->ltype)) {
$cfg = $this->cfg();
- echo '<PRE>';
- print_r($cfg);exit;
$filter = $cfg[$this->ltype];
$this->whereAddIn('lkey', $filter, 'string');
$complete = $x->fetchAll('lkey');
$list = $this->availableCodes($ltype);
- // echo '<PRE>'; print_r($list);
+ echo '<PRE>'; print_r($list);
foreach($list as $lkey) {
// skip ones we know we have done...