Mam taki skrypcik w modelu a wywala mi błąd "Column 2 is not numeric".
Ktoś ma pojęcie o co chodzi?
function jakasFunkcja()
{
$data[] = array('Rok','Miesiąc','Ilość'); $query = "SELECT
to_char(data_aaa, 'YYYY') AS rok,
to_char(data_aaa, 'MM') AS miesiac,
count(1) as ilosc
FROM ".$this->APP->config->getVar('db_tables','tabeleczka')."
WHERE to_char(data_aaa, 'YYYY')='11' AND to_char(data_aaa, 'MM') ='2010'
GROUP by rok, miesiac
ORDER BY ilosc DESC";
//var_dump($query);
//echo $query;
$result = $this->APP->db->query($query);
if (DB::isError($result))
die($result->getDebugInfo());
while ($row = $result->fetchRow())
{
$tmp[] = $row[0];
$tmp[] = (int)$row[1];
$tmp[] = (int)$row[2];
$data[] = $tmp;
}
return json_encode($data);