On Thu, 2007-08-23 at 10:17 +0800, Ow Mun Heng wrote:
> Current method.. pseudo code.
>
> while (1)
> {
> $from_datetime = time;
> $to_datetime = time + $time_interval;
>
> $query = "select count(*) from table where time >= ? and time $sth = $dbh->prepare($query)
> $sth->execute($from_datetime,
Current method.. pseudo code.
while (1)
{
$from_datetime = time;
$to_datetime = time + $time_interval;
$query = "select count(*) from table where time >= ? and time prepare($query)
$sth->execute($from_datetime, $to_datetime)
$from_datetime = $to_datetime;
}
Results:
1st time ran.. will have re
I had that problem too.
I ended up having to set to env vars to make the ? marks go away.
$ENV{NLS_LANG} = "american_america.we8iso8859p1";
$ENV{ORA_NLS} = "$ENV{ORACLE_HOME}/ocommon/nls/admin/data";
These must be set before you get a connection
-Original Message-
From: Dan King [
Peter,
The following URL's did the trick on my SuSE 10.2.
Although the white paper was for the 32 bit version the screens were
nearly identical for the 64 bit installer.
Hope this helps anyone out there with similar problems.
http://www.oracle.com/technology/software/products/database/oracle10g/
On 2007-08-21 22:01:02 -0600, jim wrote:
> The following URL's did the trick on my SuSE 10.2.
> Although the white paper was for the 32 bit version the screens were nearly
> identical for the 64 bit installer.
> Hope this helps anyone out there with similar problems.
> http://www.oracle.com/techno