Re: Table Names

2002-11-27 Thread Bart Lateur
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

Re: RowCacheSize - when to set ?

2002-11-27 Thread Tim Bunce
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

RE: RowCacheSize - when to set ?

2002-11-27 Thread Steve Baldwin
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

Re: RowCacheSize - when to set ?

2002-11-27 Thread Tim Bunce
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

Re: Problem with DBD-Informix

2002-11-27 Thread jleffler
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

RowCacheSize - when to set ?

2002-11-27 Thread Steve Baldwin
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

Re: using place holders with freetds/DBD::Sybase/MSSQL Server

2002-11-27 Thread Michael Peppler
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

Re: DBD-Informix-1.04.PC1 build errors on Solaris 8

2002-11-27 Thread jleffler
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

using place holders with freetds/DBD::Sybase/MSSQL Server

2002-11-27 Thread John Ulmer
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

Re: Subtle binding bug

2002-11-27 Thread Ronald J Kimball
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:

RE: (Fwd) need guidance on installing libdbi-perl to existing linux potato

2002-11-27 Thread Levine, Peter W
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

(Fwd) need guidance on installing libdbi-perl to existing linux potato

2002-11-27 Thread Tim Bunce
- 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

Re: Subtle binding bug

2002-11-27 Thread Tony Bowden
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

ANNOUNCE: DBD::Pg 1.20

2002-11-27 Thread David Wheeler
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

RE: no output with fetchrow_array

2002-11-27 Thread Chris Faust
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

RE: no output with fetchrow_array

2002-11-27 Thread Paul Boutros
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

Re: Subtle binding bug

2002-11-27 Thread Michael A Chase
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

Re: Is ora_session_mode working for Oracle 9i?

2002-11-27 Thread Michael A Chase
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: >

Re: no output with fetchrow_array

2002-11-27 Thread wiggins
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" <[

Re: no output with fetchrow_array

2002-11-27 Thread Peter J. Holzer
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

Re: no output with fetchrow_array

2002-11-27 Thread wiggins
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

Re: no output with fetchrow_array

2002-11-27 Thread Ronald J Kimball
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

RE: no output with fetchrow_array

2002-11-27 Thread wiggins
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

RE: no output with fetchrow_array

2002-11-27 Thread Paul Boutros
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 >

RE: no output with fetchrow_array

2002-11-27 Thread Chris Faust
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

Re: no output with fetchrow_array

2002-11-27 Thread wiggins
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

Re: no output with fetchrow_array

2002-11-27 Thread Paul Boutros
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) > > -- >

RE: Subtle binding bug

2002-11-27 Thread Jeff Urlwin
> > > 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

Re: no output with fetchrow_array

2002-11-27 Thread Hardy Merrill
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

RE: no output with fetchrow_array

2002-11-27 Thread wiggins
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

Re: Subtle binding bug

2002-11-27 Thread Tony Bowden
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

RE: Table Names

2002-11-27 Thread Chris Rogers
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

no output with fetchrow_array

2002-11-27 Thread Ramon Hildreth
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

Re: (Fwd) DBD::Oracle / alarm() problem

2002-11-27 Thread Tim Bunce
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