Re: DBI-Bind parameters

2007-08-22 Thread Ow Mun Heng
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,

DBI-Bind parameters

2007-08-22 Thread Ow Mun Heng
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

RE: Special characters

2007-08-22 Thread Nelson, Erick [HDS]
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 [

Re: (Fwd) Re: DBD::Oracle won't install for Oracle 10G XE

2007-08-22 Thread jim
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/

Re: (Fwd) Re: DBD::Oracle won't install for Oracle 10G XE

2007-08-22 Thread Peter J. Holzer
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