Postgres Pro
Downloads
Home   >   mailing lists

Thread: No output while using PEAR DB & formatted time-string

No output while using PEAR DB & formatted time-string

From
Marcus Krause
Date:
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!?

Re: No output while using PEAR DB & formatted time-string

From
Marcus Krause
Date:
Am 01.11.2003 12:00 meinte Marcus Krause:

> $query .= "SELECT news_id,to_char(news_time,'DD.MM.YYYY HH24:MI'), ";

The real code is without the comma at the end of the line above, so
it's not a simple SQL-Statement problem!