On Wed, 27 Nov 2002 08:07:39 -0500, Chris Rogers wrote:
>Thanks to all. I never imagined that I could simply issue standard sql
>statements. I prepared and executed "DESCRIBE tablename" with a
>fetchrow_hashref. It returned a nice hash reference containing all the
>information I see when I exec
On Thu, Nov 28, 2002 at 11:49:06AM +1100, Steve Baldwin wrote:
> Thanks for the reply. Is the timing a driver specific thing, or is this
> something that could go into the DBI POD ?
Driver specific.
> When you say "Use recent
> DBD::Oracle version" is that a general comment, or does the answer a
Thanks for the reply. Is the timing a driver specific thing, or is this
something that could go into the DBI POD ? When you say "Use recent
DBD::Oracle version" is that a general comment, or does the answer apply
to a particular version. We're currently on 1.03 which I know is pretty
old, but th
Set before prepare. Use trace to see effect. Use recent DBD::Oracle version.
Tim.
On Thu, Nov 28, 2002 at 11:29:20AM +1100, Steve Baldwin wrote:
> Can someone please tell me if the RowCacheSize needs to be set before
> calling 'prepare' or before calling 'execute' if I want it to be
> effective f
On Mon, 25 Nov 2002 16:29:00 -0600 Corey Herbel <[EMAIL PROTECTED]>
wrote:
> System Information at bottom of the email.
DBD::Informix v0.97005 has not been current for over two and a half years.
V1.00 hasn't been current for less than a week -- please check out v1.04.
> I can't seem to get th
Can someone please tell me if the RowCacheSize needs to be set before
calling 'prepare' or before calling 'execute' if I want it to be
effective for a SELECT statement. I'm using Oracle, so I know it is
supported, but the RowsInCache statement handle attribute returns undef,
so it's difficult to w
On Wed, 2002-11-27 at 12:26, John Ulmer wrote:
> Hello all,
>
> I am trying to use place holders to stream line some database interaction..
> RH 8 - kernel 2.4.18-18.7
> Freetds libs 0.6 (nightly build from 11/22/2002 to get around the cs_ctx_global
>problem) --with-tdsver=7.0
> Perl 5.6.1
> Perl
It looks strongly as though you've installed GCC with the name (symlink) cc.
This is not adequate; the objection to -KPIC indicates that you are not using
the Sun C compiler. Now, I'm not able to see your email while I'm typing -
I'm not at home and the webmail I'm using isn't that helpful - so I
Hello all,
I am trying to use place holders to stream line some database interaction.
RH 8 - kernel 2.4.18-18.7
Freetds libs 0.6 (nightly build from 11/22/2002 to get around the cs_ctx_global
problem) --with-tdsver=7.0
Perl 5.6.1
Perl DBI
Perl DBD::Sybase 0.95
Connecting to a MS SQL Server 7.
In
On Wed, Nov 27, 2002 at 07:00:31PM +, Tony Bowden wrote:
> On Wed, Nov 27, 2002 at 08:28:40AM -0800, Michael A Chase wrote:
> > On Wed, 27 Nov 2002 13:12:24 + Tony Bowden <[EMAIL PROTECTED]> wrote:
> > > And there's still the matter of the highly misleading error message:
> > > DBD::mysql:
Just restore your backup.
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 27, 2002 11:31 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: (Fwd) need guidance on installing libdbi-perl to existing linux
potato
- Forwarded message from ken
- Forwarded message from kenneth blue <[EMAIL PROTECTED]> -
Delivered-To: [EMAIL PROTECTED]
Date: Wed, 27 Nov 2002 10:35:22 -0800 (PST)
From: kenneth blue <[EMAIL PROTECTED]>
Subject: need guidance on installing libdbi-perl to existing linux potato
To: [EMAIL PROTECTED]
Tim:
I am new to
On Wed, Nov 27, 2002 at 08:28:40AM -0800, Michael A Chase wrote:
> On Wed, 27 Nov 2002 13:12:24 + Tony Bowden <[EMAIL PROTECTED]> wrote:
> > And there's still the matter of the highly misleading error message:
> > DBD::mysql::st execute failed: Unknown column 'nine' in 'field list'
> > The err
The uploaded file
DBD-Pg-1.20.tar.gz
has entered CPAN as
file: $CPAN/authors/id/D/DW/DWHEELER/DBD-Pg-1.20.tar.gz
size: 75821 bytes
md5: ea9e217321fb62515b3723a86ecbfcdf
This is the first release under new management at GBorg. Here's a list
of changes in the new version, along with
I have no reason at all - its just what I've gotten used to it.
When I first started working with a DB and DBI I was always thinking about
those 1 step statements (can I use it here etc.), then when it got to the
point of having a pretty large DB and doing all kinds of searches on it, I
spend the
A bit of an aside here, but
> Is this really true??
>
> >> > #here is the problem area
> >> > while ($row = $sth->fetchrow_array()) {
> >>
> >> Here you are storing your fetchrow_array to a scalar, which
> >> means $row contains the number of columns in the select (1), you
> >> need to store
On Wed, 27 Nov 2002 13:12:24 + Tony Bowden <[EMAIL PROTECTED]> wrote:
> And there's still the matter of the highly misleading error message:
> DBD::mysql::st execute failed: Unknown column 'nine' in 'field list'
>
> The error of course being nothing to do with a column 'nine', as that's
> th
On Tue, 26 Nov 2002 20:17:47 -0800 (PST) Lin Feng <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I tried to connect to a Oracle 9i db (system as sysdba) with the
> following:
>
> my $dbh = DBI->connect('dbi:Oracle:AM922X', 'system', 'pass1', {
> ora_ession_mode => 2 });
>
> and I got the following:
>
On Wed, 27 Nov 2002 16:14:30 +0100, "Peter J. Holzer" <[EMAIL PROTECTED]> wrote:
> On 2002-11-27 09:55:23 -0500, Paul Boutros wrote:
> > On Wed, 27 Nov 2002 [EMAIL PROTECTED] wrote:
> >
> > > On Wed, 27 Nov 2002 05:02:16 -0800, "Ramon Hildreth" <[
On 2002-11-27 09:55:23 -0500, Paul Boutros wrote:
> On Wed, 27 Nov 2002 [EMAIL PROTECTED] wrote:
>
> > On Wed, 27 Nov 2002 05:02:16 -0800, "Ramon Hildreth" <[EMAIL PROTECTED]> wrote:
>
> So, for me the code below works fine:
> while (my $val = $sth->fetchrow_array()) {
> push @centers, $val
On Wed, 27 Nov 2002 10:11:23 -0500, Ronald J Kimball <[EMAIL PROTECTED]> wrote:
> On Wed, Nov 27, 2002 at 09:50:19AM -0500, Chris Faust wrote:
> > Is this really true??
> >
> > >> > #here is the problem area
> > >> > while ($row = $sth->fetchrow_a
On Wed, Nov 27, 2002 at 09:50:19AM -0500, Chris Faust wrote:
> Is this really true??
>
> >> > #here is the problem area
> >> > while ($row = $sth->fetchrow_array()) {
> >>
> >> Here you are storing your fetchrow_array to a scalar, which
> >> means $row contains the number of columns in the select
Interesting two posts with the same info, must be working correctly, sorry I didn't
test. I figured fetchrow_array always returned a list, it seems weird that it would do
anything else. Personally, for readability's sake only, I wouldn't want to call a
function called fetchrow_array and have it
See below.
On Wed, 27 Nov 2002 [EMAIL PROTECTED] wrote:
> See inline.
>
>
>
> On Wed, 27 Nov 2002 05:02:16 -0800, "Ramon Hildreth" <[EMAIL PROTECTED]> wrote:
>
> > Hi, I am not getting any output using the below code.
> >
> > #!/usr/bin/perl
>
Is this really true??
>> > #here is the problem area
>> > while ($row = $sth->fetchrow_array()) {
>>
>> Here you are storing your fetchrow_array to a scalar, which
>> means $row contains the number of columns in the select (1), you
>> need to store it to an array:
I do this all the time when I k
Agreed. I tried to stick as close to the original poster's code. Recently I much
prefer calling fetchrow_hashref and having everything in that one little bundle, but I
felt that might be a big jump to make...
And of course we could always go down the road of 'selectcol_arrayref' since he was
on
I think you want to use $row and not $_ in your push statement
On Wed, 27 Nov 2002, Ramon Hildreth wrote:
> Hi, I am not getting any output using the below code.
>
> #!/usr/bin/perl
>
> use strict;
> use warnings;
> use DBI;
> --
> connecting to database (okay with this, it works)
>
> --
>
>
>
> On Mon, Nov 25, 2002 at 07:48:14AM -0800, Michael A Chase wrote:
> > > I'm assuming that the first time the statement is executed
> something is
> > > trying to work out whether the field is numeric or string,
> and seeing a
> > > number, assumes it's numeric. But then, every future inser
Comments below.
[EMAIL PROTECTED] [[EMAIL PROTECTED]] wrote:
> See inline.
>
>
>
> On Wed, 27 Nov 2002 05:02:16 -0800, "Ramon Hildreth" <[EMAIL PROTECTED]> wrote:
>
> > Hi, I am not getting any output using the below code.
> >
> > #!/usr/bin/per
See inline.
On Wed, 27 Nov 2002 05:02:16 -0800, "Ramon Hildreth" <[EMAIL PROTECTED]> wrote:
> Hi, I am not getting any output using the below code.
>
> #!/usr/bin/perl
>
> use strict;
> use warnings;
> use DBI;
> --
> connecting to database (oka
On Mon, Nov 25, 2002 at 07:48:14AM -0800, Michael A Chase wrote:
> > I'm assuming that the first time the statement is executed something is
> > trying to work out whether the field is numeric or string, and seeing a
> > number, assumes it's numeric. But then, every future insert fails, with
> > a
Thanks to all. I never imagined that I could simply issue standard sql
statements. I prepared and executed "DESCRIBE tablename" with a
fetchrow_hashref. It returned a nice hash reference containing all the
information I see when I execute the same statement in mysql. Again thanks
to all.
Chris
Hi, I am not getting any output using the below code.
#!/usr/bin/perl
use strict;
use warnings;
use DBI;
--
connecting to database (okay with this, it works)
--
my (@centers, $stmt, $sth, $row);
$stmt = qq { SELECT group_center FROM places};
$sth = $dbh->prepare($stmt);
$sth->execute();
#here i
Got a moment to gve this more thought...
>
> #!/usr/SD/perl/bin/perl
>
> #use DBD::Oracle;
> use DBI;
>
> $SIG{ALRM} = sub { print "Caught alarm\n"; };
>
> alarm (2);
> $dbh = DBI->connect('dbi:Oracle:eman', 'eman', 'eman');
> alarm (0);
>
> sleep(5);
> print "Success\n";
>
>
> If t
34 matches
Mail list logo