Dear all
i am having a problem with SQL-Statement-1.005, whereas
SQL-Statement-0.1020 is working fine.
SQL ERROR: Mismatched parentheses in WHERE clause!
SV = RV(0x810cad0) at 0x829105c
REFCNT = 1
FLAGS = (PADBUSY,PADMY,ROK)
RV = 0x83844e4
DBD::CSV::st execute failed: dbih_getcom handle
this seems to have changed since i installed DBI 1.32 (i upgraded from 1.30),
and is breaking some scripts which assume that it will always return a hash.
sometimes (when the query returns no rows), it returns the scalar 1 -
attempting to use that as a hashref causes the script to die (with
Mark,
The solution you suggested worked fine for my install of DBI, however I
then encountered the same error when building the DBD::DB2 module.
Unfotunately, the DBAs are not happy about putting the DB2 Application
Development Client (a pre-req to the install) on the box I used last time
to
Can you post an example script that calls selectrow_hashref and
demonstrates the problem?
Tim.
On Fri, Feb 14, 2003 at 01:18:56PM +1100, Craig Sanders wrote:
this seems to have changed since i installed DBI 1.32 (i upgraded from 1.30),
and is breaking some scripts which assume that it will
Does anybody know where IBM publish sample Perl code for their UDB/DB2 (dbh)
structures. I am using Solaris; Linus and AIX.
Thanks
_
Get Free Web email Account from the MetroCentre --- http://www.metro-centre.co.uk
I did not see a lot of sample script regarding perl and DB2 but if you want
tell me what kind of example you are looking for and I will sent you a
couple of script I've made. I use DB2 and Perl on a regulary basis.
Stéphane Legault, ing.
Services Mondiaux IBM
IBM Canada Ltée
Architecte,
Hi,
I still have the default max number of database connections (32), but
instead of increasing it I want the connections to be closed down
after being used. I get an increasing number of these:
postgres 22906 695 0 13:40 ? 00:00:00 postgres: apache testdb [local]
postgres 22913 695 0 13:41 ?
Holding cursors open is a feature.
Really. :)
Keeping cursors open for reuse can save a lot of
time. Just because you close the cursor in the your
program does not mean Oracle will close it also.
Have your DBA's session_cached_cursors. This is
the number of cursors that will be cached in the
Try an Oracle list.
There's instruction for joining one at:
http://www.cybcon.com/~jkstill/util/maillist/maillist.html
Jared
On Thursday 13 February 2003 06:36, Morrison Davis wrote:
This is probably more of an oracle problem than DBI problem but I'm
getting desperate. I can connect
from
In DBD::Informix, there is an attribute for $dbh for ix_InTransaction which does this
for you.
It is not standardized.
---Original Message---
From: Roger Perttu [EMAIL PROTECTED]
When I destroy my objects I would like to know if there are uncommitted
transactions. There shouldn't be
Roger Perttu wrote:
Hi!
When I destroy my objects I would like to know if there are
uncommitted transactions. There shouldn't be any but I would like to
know. Given only a DBI database handle, is it possible to find out if
there are uncommitted transactions? If not, is there anything inside
Has anyone installed ActiveState Perl 5.8.0 Build 805?
I did on a test machine, and installed the DBI package with the PPM3
interface. It could not locate the DBD-DB2 package. When I added the
'repository' for DBD-DB2, PPM refused to install it for binary
incompatibility.
I've been using these
perl 5.6.1
With use warnings, dependant upon the query I execute, I will recive the
following: Use of uninitialized value in join or string. I see this when
I am selecting against v$ views and not when I use a table/view
without a $ in the name. I'm assuming at this point that perl is parsing
Try changing all of your $ that are not variables to \$
perl 5.6.1
With use warnings, dependant upon the query I execute, I will
recive the
following: Use of uninitialized value in join or string.
I see this when I am selecting against v$ views and not when
I use a table/view
On Fri, Feb 14, 2003 at 01:31:00PM -0500, Markham, Richard wrote:
perl 5.6.1
With use warnings, dependant upon the query I execute, I will recive the
following: Use of uninitialized value in join or string. I see this when
I am selecting against v$ views and not when I use a table/view
Thanks ronald for your assistance
~~snip~~
$dbh-{RowCacheSize} = 100;
my $sql=q{ select * from v$instance };
print Preparing SQL\n;
my $sth = $dbh-prepare($sql);
print Executing SQL\n;
$sth-execute;
while (my $ary = $sth-fetchrow_arrayref) {
print @{$ary}\n;
}
$sth-finish;
On Fri, Feb 14, 2003 at 01:50:05PM -0500, Markham, Richard wrote:
while (my $ary = $sth-fetchrow_arrayref) {
print @{$ary}\n;
}
Use of uninitialized value in join or string at C:\DOCUME~1\edp18\un.pl line
70.
1 DEV erpd3 8.1.7.2.0 09-FEB-03 OPEN NO 1 STOPPED ALLOWED NO ACTIVE
Hi Ed,
I had a similar problem with the Sybase module, and I went back to perl
5.6.1.
The Sybase module says it needs perl 5.6 libraries (somehow) so it fails.
Until someone compiles a 5.8 specific version (not me, don't have the
time!) you'll have to use ODBC, or use 5.6.
(This is in XP BTW)
Walter B. Takens wrote:
Dear all
i am having a problem with SQL-Statement-1.005, whereas
SQL-Statement-0.1020 is working fine.
SELECT KOLOM1,KOLOM8,KOLOM5,KOLOM6,KOLOM7 FROM MYTABLE
WHERE ( ( ( ( KOLOM4 = '123456' OR KOLOM4 = '' ) AND KOLOM3 = '127' )
OR KOLOM8 = 'TRUE' ) AND KOLOM1 = 'bla'
Dan Muey wrote:
Before
SELECT KOLOM1,KOLOM8,KOLOM5,KOLOM6,KOLOM7 FROM MYTABLE
WHERE ( ( ( ( KOLOM4 = '123456' OR KOLOM4 = '' ) AND KOLOM3
= '127' )
OR KOLOM8 = 'TRUE' ) AND KOLOM1 = 'bla' )
Does this query work from the command line app?
It seems to me it wouldn't becaue you have 4 ('s and
Hi,
I need a bit of a help with DBI/DBD combo. I have tried to narrow it
down and came up with the following.
Here is the problem summary:
Versions:
Perl: 5.6.1
DBI: 1.32
DBD-Oracle: 1.12
Operating System: Solaris 5.8
Oracle version: 8.1.7
Description:
21 matches
Mail list logo