You would normally only expect $sth->{NAME} to be populated if the statement
handle was returning a result set, as in a SELECT statement.
BTW, as far as I know there in no point in the prepare/execute/finish
methods for the DDL stuff you are doing. These are used in DML type stuff
(select, delet
Hi Ron,
> > use DBI;
> > DBI->trace(3, "trace.log");
> > my $dbh = DBI->connect('DBI:ODBC:testdb', 'sa', '');
> > my $sth = $dbh->prepare("create table foo (a int)");
> > $sth->execute;
>
> $sth -> finish();
>
> > $sth = $dbh->prepare("alter table foo add b int");
> > $sth->execute;
> > my $name
On Thu, 08 Jan 2004 10:14:59 -0800, Alex Krohn wrote:
Hi Alex
> use DBI;
> DBI->trace(3, "trace.log");
> my $dbh = DBI->connect('DBI:ODBC:testdb', 'sa', '');
> my $sth = $dbh->prepare("create table foo (a int)");
> $sth->execute;
$sth -> finish();
> $sth = $dbh->prepare("alter table foo add b i
Giving a clue about which version of the DBI you're using would help.
Tim.
On Thu, Jan 08, 2004 at 04:53:30PM -0500, David Mann wrote:
>
> I see some chatter about this failure but have yet to resolve it, any
> takers.
>
> Here's the snippet from "perl -Mblib t/40profile.t"
>
> ok 19
> not
I am aware that there are more problems for people using utf8 locales
with RH9 perl. But we're getting off topic.
Tim.
On Thu, Jan 08, 2004 at 12:41:50PM -0600, [EMAIL PROTECTED] wrote:
>
> I did say to be fair, I have not tried the perl that comes with RH9.
> I just thought I would mention it,
I see some chatter about this failure but have yet to resolve it, any
takers.
Here's the snippet from "perl -Mblib t/40profile.t"
ok 19
not ok 20
# Failed test 20 in t/40profile.t at line 93
profile data: [1951 0.15485954284668 0.000340938568115234
-0.00647091865539551 0
.00459194183349609 1
I did say to be fair, I have not tried the perl that comes with RH9.
I just thought I would mention it, since I know somebody that was
having problems the the RH9 perl. Which could be an isolated instance.
On 08-Jan-2004 Hardy Merrill wrote:
<[EMAIL PROTECTED]> 01/08/04 01:26PM >>>
> I beg
>>> <[EMAIL PROTECTED]> 01/08/04 01:26PM >>>
I beg to differ - I've used RH9 with the Perl and DBI that come with
the distribution and I've never had a problem with it.
Hardy Merrill
This may be totally unrelated, but I had a friend email me about the
Vendor Perl
not working correctly on RH9. I
This may be totally unrelated, but I had a friend email me about the Vendor Perl
not working correctly on RH9. I encouraged him to compile 5.8.1 or 5.8.2, I have
had nothing but trouble using the /usr/bin/perl that is shipped with RedHat. One
of the biggest my complaints is that LARGEFILE_SOURCE
Server Info:
DBI: 1.39
DBD::mysql: 2.9003
MySQL Version: - 4.0.15-standard
Perl ver.: 5.8.0
RedHat/Linux 9.0
thx's
--
MikeBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
=-=-=-=-=-=-=-=-=-=-=-=-
Hi,
The following script:
use DBI;
DBI->trace(3, "trace.log");
my $dbh = DBI->connect('DBI:ODBC:testdb', 'sa', '');
my $sth = $dbh->prepare("create table foo (a int)");
$sth->execute;
$sth = $dbh->prepare("alter table foo add b int");
$sth->execute;
my $names = $sth->{NAME};
$sth->finish;
$dbh->d
The module is called 'DBI' not 'dbi'.
--
Ed Avis <[EMAIL PROTECTED]>
What version of DBD/DBI are you using and on what platform? The exact
same thing happened to me on SunOS (don't remember the exact DBD/DBI
version). I upgraded to the lastest DBD/DBI and the problem went away.
HTH,
Keith
On Thu, 2004-01-08 at 11:40, Mike Blezien wrote:
> Hello all,
>
> this
With "DBI", I'm get the same error:
PPM> install DBI
Install package 'DBI?' (y/N): y
Installing package 'DBI'...
Error installing package 'DBI': Could not locate a PPD file for package DBI
PPM>
-Mensaje original-
De: Avis, Ed [mailto:[EMAIL PROTECTED]
Enviado el: Thursday, January 08, 200
On Thu, Jan 08, 2004 at 10:40:34AM -0600, Mike Blezien wrote:
> ... suggestions would be appreciated. :)
Use trace.
Tim.
When I try to do it, I get the following message:
C:\>ppm
PPM interactive shell (2.2.0) - type 'help' for available commands.
PPM> install dbi
Install package 'dbi?' (y/N): y
Installing package 'dbi'...
Error installing package 'dbi': Could not locate a PPD file for package dbi
PPM>
Can anybody,
Hello all,
this one has been driving me nuts!! Below is a snip of code within a eval { }
for transactions.
Everything gets inserted correctly but for some reason the $ary_ref->[$i] values
are always '0', they should be the `signupid` values from the `subscriptions`
table.
In the 1st INSERT st
I'll look into that. Next server I upgrade I will pay more attention to the
details on each step to see where the @INC is getting altered.
Thanks,
STH
On 07-Jan-2004 Tim Bunce wrote:
> Maybe your CPAN.pm config is altering @INC someho
Steffen Goeldner wrote:
Peter Hircock wrote:
Correct, the problem starts with version 2.77, 2.76 is fine.
Short explanation:
The execute() method of DBD::ADO 2.77 returns $rows instead of
$rs->RecordCount (because it seems more reliable).
The type of $rows is Win32::OLE::Variant, whi
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.40.tar.gz
size: 303642 bytes
md5: 89dbbee6094b6c7c9bb33ddcb7a21b94
=head2 Changes in DBI 1.40,7th January 2004
Fixed handling of CachedKids when DESTROYing threaded handles.
Fixed sql_user_name() in DBI::DBD::Metadata (used by write_getinfo_pm
- Forwarded message from Jordi Valls Ferrer <[EMAIL PROTECTED]> -
Delivered-To: [EMAIL PROTECTED]
From: "Jordi Valls Ferrer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: DBI with Apache 1.3.x
Date: Thu, 8 Jan 2004 14:50:59 +0100
Hi Tim, i'm in your perl list distribution since
On Thu, Jan 08, 2004 at 12:18:25PM +, Sean Kelly wrote:
> Quoting [EMAIL PROTECTED]:
>
> > I'm using Solaris 8 on a SPARC machine and Perl is already installed. I
> > want to install the DBI module so I can star talking with my databases,
> > but I don't know how to do this. I checkout out a f
I just built it on the same platform. You have to build your own perl. Read
the README.hpux in the perl source directory and the README.hpux in
DBD-Oracle. It tells exactly how to do it
-Original Message-
From: Mohammed Maati [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 9:1
Quoting [EMAIL PROTECTED]:
> I'm using Solaris 8 on a SPARC machine and Perl is already installed. I
> want to install the DBI module so I can star talking with my databases,
> but I don't know how to do this. I checkout out a few websites and some
> said to use "perl -? CPAN" or something like th
Peter Hircock wrote:
> Correct, the problem starts with version 2.77, 2.76 is fine.
Short explanation:
The execute() method of DBD::ADO 2.77 returns $rows instead of
$rs->RecordCount (because it seems more reliable).
The type of $rows is Win32::OLE::Variant, which obviously cannot
be r
Hi, I am having issues building DBD::Oracle on an HP-UX B.11.00 U 9000/800 PA-RISC sever. The "perl Makefile.PL" and "make" steps work fine but "make test" does not go through.
The details of the Oracle database are below in the output of "perl Makefile.PL -v".
I did not build perl, I downloaded
I'm using Solaris 8 on a SPARC machine and Perl is already installed. I want to
install the DBI module so I can star talking with my databases, but I don't know how
to do this. I checkout out a few websites and some said to use "perl -? CPAN" or
something like that, but that didn't work and I do
27 matches
Mail list logo