Hi all.
I'm pleased to announce the 1st release of my 2nd open-source project:
PDF::ReportWriter.
It's designed to assist in making high-quality business reports for
archiving or printing, and uses PDF::API2 to render directly to PDF.
Supported features:
- html-table-like layout engine
- text
On Mon, Apr 25, 2005 at 04:38:28PM -0700, Joel Stevenson wrote:
Can you post the next few lines from the trace, upto just after
fetchrow_hashref returns?
Sure,
snip
!! ERROR: 1146 CLEARED by call to fetchrow_hashref method
- fetchrow_hashref for DBD::mysql::st
2005-04-25 Darren Duncan [EMAIL PROTECTED]
--
Version 0.60 of SQL::Routine (SRT), a fully atomic and portable
abstract syntax tree to define any database tasks, has been uploaded
to CPAN; it should appear on your favorite mirror within the next
Hi,
When I install DBD::Oracle module, I get the following error.
=
ld: fatal: file /oracle/product/10/lib//libclntsh.so: wrong ELF class:
ELFCLASS64
ld: fatal: File processing errors. No output written to
blib/arch/auto/DBD/Oracle/Oracle.so
collect2: ld returned 1
On 04/26/2005 03:54 AM, PerlDiscuss - Perl Newsgroups and mailing lists
said:
When I install DBD::Oracle module, I get the following error.
=
ld: fatal: file /oracle/product/10/lib//libclntsh.so: wrong ELF class:
ELFCLASS64
...
Summary of
On Mon, 25 Apr 2005, James D. White wrote:
I have a couple of suggested patches for DBD::mysql. These patches were
based upon
DBD-mysql-2.9006.
The first patch is to correct a typo in t/lib.pl.
47c47
$::test_password = $::test_passowrd || $ENV{'DBI_PASS'} || '';
---
On 4/26/05 9:03, Rudy Lippan [EMAIL PROTECTED] wrote:
On Mon, 25 Apr 2005, James D. White wrote:
I have a couple of suggested patches for DBD::mysql. These patches were
based upon
DBD-mysql-2.9006.
The first patch is to correct a typo in t/lib.pl.
47c47
$::test_password =
I would like to select several rows from one table
and insert them into another nearly identical table
using Perl/DBI:
my @array = $q-param(); # HTML checkboxes
foreach my $element (@array) {
my $sql = select col2, col3, col4 from table1
where col1 = ?;
my $sth =
Jonathan Mangin wrote:
I would like to select several rows from one table
and insert them into another nearly identical table
using Perl/DBI:
my @array = $q-param(); # HTML checkboxes
foreach my $element (@array) {
$dbh-do(INSERT INTO t (col1, ...) SELECT col1, ... FROM t2 WHERE x
=
This is very inefficient ...
1. You are prepare()ing your SQL statements in a loop.
2. You are performing row-at-a-time processing
Move your SQL statements out the loop. This will be a big performance gain (in
a high transaction app).
However (in Oracle), this would best be accomplished by
$dbh-do(INSERT INTO t (col1, ...) SELECT col1, ... FROM t2 WHERE x
= '$element');
Oi SQL injection warning! Red lights and sirens - don't do that!!
'$element' is supper dangerouse, evil evil evil
either $dbh-quote it or use ? in your prepare/execute dance:
$dbh-do( 'INSERT INTO t
- Original Message -
From: Philip M. Gollucci [EMAIL PROTECTED]
To: Jonathan Mangin [EMAIL PROTECTED]
Cc: dbi-users@perl.org
Sent: Tuesday, April 26, 2005 3:19 PM
Subject: Re: Efficient select/insert
Jonathan Mangin wrote:
I would like to select several rows from one table
and insert
At 01:13 PM 4/26/2005, Jonathan Mangin wrote:
I would like to select several rows from one table
and insert them into another nearly identical table
using Perl/DBI:
my @array = $q-param(); # HTML checkboxes
foreach my $element (@array) {
my $sql = select col2, col3, col4 from table1
- Original Message -
From: Eric [EMAIL PROTECTED]
To: Jonathan Mangin [EMAIL PROTECTED]; dbi-users@perl.org
Sent: Tuesday, April 26, 2005 3:43 PM
Subject: Re: Efficient select/insert
At 01:13 PM 4/26/2005, Jonathan Mangin wrote:
I would like to select several rows from one table
and
The load_dbnames() function does not handle tnsnames.ora files properly. It
scans _the_ file looking for leading edge database connection names, but it
doesn't honor the ifile directive.
The ifile directive basically does an include of the specified file(s) which
may contain other ifile
Hi,
I have fresh install Solaris 9. We have some perl scripts to run. I am
getting Can't locate DBI.pm error to execute the file. We access
oracle 9 from this perl script. Can some one help me to fix this
problem?
My Perl version is:
This is perl, v5.6.1 built for sun4-solaris-64int
(with 48
Is DBI installed? Is it your @INC path?
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Chekuri, Lalitha [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 26, 2005 10:10 AM
To: dbi-users@perl.org
Subject: Can't locate DBI.pm
Hi,
I have fresh install
Are you sure this is the perl where DBI is installed. If you reinstall
solaris 9, the prebuilt perl on the box from the install will not have the
DBI and DBD-Oracle installed. You will need to compile these yourself.
Date: Tue, 26 Apr
2005 12:10:21 -0400
From: Chekuri, Lalitha [EMAIL
At 02:13 PM 4/26/2005, Jonathan Mangin wrote:
- Original Message - From: Eric [EMAIL PROTECTED]
To: Jonathan Mangin [EMAIL PROTECTED]; dbi-users@perl.org
Sent: Tuesday, April 26, 2005 3:43 PM
Subject: Re: Efficient select/insert
At 01:13 PM 4/26/2005, Jonathan Mangin wrote:
I would like
How do I compile?
-Original Message-
From: Michael Nhan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 26, 2005 5:28 PM
To: Chekuri, Lalitha
Cc: dbi-users@perl.org
Subject: Re: Can't locate DBI.pm
Are you sure this is the perl where DBI is installed. If you reinstall
solaris 9, the
Do these selects first and push the results into an array of arrays. Then
prepare your insert and loop through your array on the execute portion
only. Short of multiline inserts that should be your fastest way to do
things.
Doesn't this (below) affect my ability to do that?
I don't really know.
Google is your friend ...
http://www.google.com/search?q=install+perl+modulessourceid=mozilla-searchstart=0start=0ie=utf-8oe=utf-8client=firefox-arls=org.mozilla:en-US:official
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Chekuri, Lalitha
22 matches
Mail list logo
