On Thu, Feb 21, 2002 at 04:41:37PM -0500, Kevin White wrote:
> I'm having trouble with Perl scripts that to a select of a date field,
> specifically in the enclosed test, a timestamp(6).
>
> Attached are the files requested in the README.
>
> I'm using Red Hat Linux 7.1 and Oracle 9.0.1. Perl i
I'm having trouble with Perl scripts that to a select of a date field,
specifically in the enclosed test, a timestamp(6).
Attached are the files requested in the README.
I'm using Red Hat Linux 7.1 and Oracle 9.0.1. Perl is 5.6.0, DBI is
1.21, DBD-Oracle 1.12.
When I select a timestamp field,
On Sun, Feb 17, 2002 at 01:28:30PM -0800, Jeffrey W. Baker wrote:
>
> Aside: It seems that DBI is willing to call into the DBD implementation
> to fetch (dbd_st_fetch) even on handles which have been invalidated by
> disconnection. Should not these statement handles have Active marked
> FALSE u
Thanks Garth! and good luck ...
--- Tim Bunce <[EMAIL PROTECTED]> wrote:
> Thanks for all your help in the early years, Garth.
> [*]
>
> I wish you every happiness in your retirement.
>
> Tim.
>
> [*] For those who don't know, Garth was one of the
> early pioneers
> and contributors to the DBp
Thanks for all your help in the early years, Garth. [*]
I wish you every happiness in your retirement.
Tim.
[*] For those who don't know, Garth was one of the early pioneers
and contributors to the DBperl project that later became the DBI.
On Thu, Feb 21, 2002 at 06:58:38AM -0600, Garth Kenned
On Wed, Feb 13, 2002 at 05:51:35AM -0500, Rob Ransbottom wrote:
> On Tue, 12 Feb 2002, Tim Bunce wrote:
>
> > > : Does anyone here know if DBD::Pg starts a new transaction after a
> > > : COMMIT? That is, it appears that...
>
> > the driver is free to not start a new transaction until the appli
On Wed, Feb 20, 2002 at 11:12:43PM +0100, Nicolas JOURDEN wrote:
> Hi,
>
> Once, you have finish your fetch you'll need to free memory using :
> $sth->finish();
No. You don't. Reread the docs for finish() carefully.
Tim.
> It'll be better than nothing.
>
> Moreover if your computer came down
On Wed, Feb 20, 2002 at 10:36:27AM -0700, Sterin, Ilya wrote:
> DBI: 1.18 (I have compiled using gcc)
Upgrade.
Tim.
Hermann Altmann writes:
> Hi,
>
> Each time I connect to a MSSQL 7.0 Database via
>
> $dbh = DBI->connect("dbi:Sybase:server=$dbserv;database=$dbname",
> $dbuser, $dbpass, {AutoCommit => 0 }) || die $DBI::errstr;
>
> I get the messages on stderr:
>
> Datenbankkontext auf 'm
On Tue, Feb 19, 2002 at 03:49:21PM -0600, Jeremy Keeler wrote:
> Greetings dbi-users,
>
> Does the newest version of DBD::Oracle fully support the SQL_CLOB type?
Yes if built to use the Oracle 8 OCI API.
> That gave me the error message:
> "DBD::Oracle::st execute failed: ORA-01461: can bind a
On Mon, Feb 18, 2002 at 01:20:33PM -0600, Dave Rolsky wrote:
> On 18 Feb 2002, Jeff Boes wrote:
>
> > Is it true that RowCacheSize has no effect with the DBD::Pg driver? The
> > DBD::Pg doc just says that it's "Implemented by DBI, not used by
> > driver", which implies that DBI actually does som
Hi,
Each time I connect to a MSSQL 7.0 Database via
$dbh = DBI->connect("dbi:Sybase:server=$dbserv;database=$dbname",
$dbuser, $dbpass, {AutoCommit => 0 }) || die $DBI::errstr;
I get the messages on stderr:
Datenbankkontext auf 'master' geändert.
Changed language setting to us_e
Your "DATE" column in the tableABC is a reserved word
and is probably the cause (unless you are on Sybase or
SQL server).
Anyway,
do this at beg of script.
DBI->trace( 2 );
run from cmd line, send the output if you don't get
it.
--- "Ho, Tony" <[EMAIL PROTECTED]> wrote:
> Hi Tim,
> Thanks for
On Wed, Feb 13, 2002 at 03:46:36PM -0800, Jeffrey W. Baker wrote:
> A bug in DBD::Pg can cause it to loop infinitely or crash when ping() is
> called on a disconnected database handle. In the disconnect() method,
> DBD::Pg calls PQfinish() which closes the connection and *frees the
> memory for t
gotcha.
Hey, on the support issue... I guess I'm just not
sure what we are entitled to via the purchase alone.
We payed around $1K for the ODBC::ODBC bridge
software. Being legal is important to us. I was just
wandering if there was an additional yearly fee or
something like that for support.
Hi Tim,
Thanks for the email.
Unfortunately, I am getting the same results.
I tried your suggestion and also I tried :
$sth = $dbh->prepare("select
ITEM_ID,
START_DATE,
END_DATE
from tableABC
Tony,
try this:
$sth = $dbh->prepare("select
ITEM_ID,
START_DATE,
END_DATE
from tableABC
where ACCOUNT = ?
and SEQ =
and DATE = ");
$sth->e
On 21-Feb-2002 Tim Harsch wrote:
> Martin, Jeff et al.
> You guys nailed it I think. I think in my previous
> working set up I had I must have chosen
> /usr/local/easysoft/oob/client as my ODBCHOME
>
> For this failed build of ODBC 0.38 I had been choosing
>
> /usr/local/easysoft/unixODBC a
Martin, Jeff et al.
You guys nailed it I think. I think in my previous
working set up I had I must have chosen
/usr/local/easysoft/oob/client as my ODBCHOME
For this failed build of ODBC 0.38 I had been choosing
/usr/local/easysoft/unixODBC as my ODBCHOME
I switched back to
/usr/local/easy
On 21 Feb 2002, at 9:06, Shao, Chunning wrote:
>
> >AFAIK unused memory is not returned to the system from Perl
> >processes. A workaround is to fork() out the memory consuming steps
> >into a child process, the memory of which is freed when the child
> >exits.
>
> HTH
>
> Bodo
>
>
> Could
related question, is the consumed memory returned when perl process
completes under mod_perl?
On Thu, 21 Feb 2002, Shao, Chunning wrote:
> Date: Thu, 21 Feb 2002 09:06:25 -0500
> From: Shao, Chunning <[EMAIL PROTECTED]>
> To: Bodo Eing <[EMAIL PROTECTED]>, phinney <[EMAIL PROTECTED]>
> Cc: [EMA
Hi Tim,
Thanks for the emsil.
I previously used "effective_date" as well as date.
Unfortunately, the code didn't work well.
Cheers
Tony
-Original Message-
From: Tim Harsch [mailto:[EMAIL PROTECTED]]
Sent: 21 February 2002 17:34
To: Jeff Urlwin; Ho, Tony; [EMAIL PROTECTED]
Subject: RE: DB
Hi Jeff
Thanks for correction.
The correct version of the code is as follows :
$sth = $dbh->prepare("select
ITEM_ID,
START_DATE,
END_DATE
from tableABC
where ACCOUNT = $account
You should also probably be using placeholders ie
"date = ?"
For portability reasons I suggest you change the name
of the "date" column to something else. It is a
reserved word in most databases. I'm guessing your
using Sybase or SQL Server.
--- Jeff Urlwin <[EMAIL PROTECTED]> wrote:
> >
> > H
>
> Hi guys
> I was wondering if you could help me.
> I have the following SQL query on command-line and I get the
> resulting data
> :
>
> 1> select ITEM_ID,START_DATE, END_DATE from tableABC where ACCOUNT = 2435
> and
> SEQ = 16 and DATE = 19971208
> 2> go
> ITEM_ID START_DATE
Hi guys
I was wondering if you could help me.
I have the following SQL query on command-line and I get the resulting data
:
1> select ITEM_ID,START_DATE, END_DATE from tableABC where ACCOUNT = 2435
and
SEQ = 16 and DATE = 19971208
2> go
ITEM_ID START_DATE END_DATE
--
There are a number of cpan tools that will do that - you just basically need
anything that will do julian or other time format conversion. I have seen
others use Time::Calc and I tend to prefer Time::Manip.
Scott
--- Charitha <[EMAIL PROTECTED]> wrote:
>
>
> Hello all,
>
> Can i find the dif
>AFAIK unused memory is not returned to the system from Perl
>processes. A workaround is to fork() out the memory consuming steps
>into a child process, the memory of which is freed when the child
>exits.
HTH
Bodo
Could you give us examples how to do it? I have the same problem.
Thanks
phinney [[EMAIL PROTECTED]] wrote:
> Hello all...
>
> I have a DBI call that returns a long list of names (10,000). I am
> using fetchall_arrayref. The call seems to take up 40MB of memory. Is
> this normal? Am I doing something wrong? Is there any special way to
> free up this memory.
A
On 21-Feb-2002 Tim Harsch wrote:
> Hi all,
> Here's more info on the ODBC not connecting problem.
> It doesn't seem to provide much insight, maybe you'll
> have better luck though ...
>
> -
> Here's a DBI trace of a simple connect attempt:
>
> DBI 1.21-nothread dispatch trace level se
On Wed, 2002-02-20 at 21:41, schoen wrote:
> You probably have not defined the TST data source.
> Try adding these 3 lines to /var/spool/sql/ini/odbc.ini (create the file if
> it does not exist):
> [TST]
> ServerNode=localhost
> ServerDB=TST
>
Thx, schoen, I did have this file, but in de /var/spo
On 20-Feb-2002 Tim Harsch wrote:
> Here's an install session. I'm pretty sure that test
> 9 failing has nothing to do with the fact that I can't
> log in anymore.
09multi failing was a bug in the OOB when SQLMoreResults
was called and the columns in the new result-set were fewer
than in the pre
On 20 Feb 2002, at 17:02, phinney wrote:
> Hello all...
>
> I have a DBI call that returns a long list of names (10,000). I am
> using fetchall_arrayref. The call seems to take up 40MB of memory.
Is it the perl process or your database consuming the memory?
A list of 10,000 strings (30 charac
33 matches
Mail list logo
