From: Marcus Krause <marcus.k79@expires-2003-11-30.arcornews.de>
To: pgsql-sql@postgresql.org
Subject: No output while using PEAR DB & formatted time-string
Date: Sat, 01 Nov 2003 12:00:16 +0100
Message-ID: <bo03pg$1pva$1@news.hub.org> (raw)
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!?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: marcus.k79@expires-2003-11-30.arcornews.de
Subject: Re: No output while using PEAR DB & formatted time-string
In-Reply-To: <bo03pg$1pva$1@news.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox