No output while using PEAR DB & formatted time-string

Поиск
Список
Период
Сортировка
От Marcus Krause
Тема No output while using PEAR DB & formatted time-string
Дата
Msg-id bo03pg$1pva$1@news.hub.org
обсуждение исходный текст
Ответы Re: No output while using PEAR DB & formatted time-string
Список pgsql-sql
Дерево обсуждения 
I have a problem in using the to_char function in a SQL-Statement
and addressing it with DB_FETCHMODE_OBJECT under PEAR DB.

The follwing code is working fine unless I'm adding the to_char function:

--------------------------------------------------------------
require_once 'DB.php';
$dsn = $$$;
$db = DB::connect($dsn);
$db->setFetchMode(DB_FETCHMODE_OBJECT);

$query .= "SELECT news_id,to_char(news_time,'DD.MM.YYYY HH24:MI'), ";
$query .= "FROM News ";
$query .= "WHERE news_id=$var";
$sth = $db->query($query);

while($newsid_row=$sth->fetchRow()) {     print <<<HTML     $newsid_row->news_id<br>  <!-- there's an output -->
$newsid_row->news_time<br><!-- there's no output -->     blabla
 
HTML;
}
$db->disconnect();

--------------------------------------------------------------

Has anybody an idea to get this working or similar experiences?

Thanks for your patience; could be the wrong newsgroup!?

В списке pgsql-sql по дате отправления: