Here you are just flattening the hash which will produce a list of keys and
values. You need to use foreach $key (keys %hash) to loop through each key
and construct you query.
Ilya
-Original Message-
From: Victor Flores
To: [EMAIL PROTECTED]
Sent: 08/02/2001 8:09 AM
Subject: RE: How do
Hi All,
OK, now I have a really weird problem. It didn't seem to happen before but
now...
I'm building an application on Solaris using Oracle 8i, Perl 5.6.1, DBI on
Apache with mod_perl and Apache::DBI (). I've discovered that somewhere
along the line, one of these components seems to be caching
> From: Sterin, Ilya
>
> It's actually use DBI (uppper case) not use dbi. Perl is
> case sensitive.
Actually, since windows is not case-sensitive when it comes to
file names, it will find the DBI.pm file ok, and 'require' it ok,
but nothing will be exported from the DBI package (since there
Seems odd that it's trying to dynamically load what look like static
(.a) libraries.
[EMAIL PROTECTED] is the place to ask for help building perl.
(and use at least perl5.6.1 or 5.7.1)
Tim.
On Wed, Aug 01, 2001 at 10:05:12AM -0400, [EMAIL PROTECTED] wrote:
> Hi all (especially you IBMers out th
Has anyone experienced problems getting a previously
happy Perl DBI, DBD-oracle drive refuse to connect to
the database.
I`ve added various lines to tell report back the
errors but they aren`t giving me enough clues.
One that does crop up is
DBI->connect failed: ORA-12203: TNS:unable to conne
Hello,
Is it possible and/or advisable to use place holders to do mass deletion in a
table??
something like this:
$selquery = qq|SELECT memid FROM optin WHERE time > NOW()|;
$sth = $dbh->prepare($selquery);
$delquery = qq|DELETE FROM members WHERE memid > ?|;
$dbh->do($delquery);
while ($ids =
I've been charged with the task of migrating our
current report generation program from sqlplus
to perl DBI. So far, all the scripts seem to work
well after I strip the formatting information out
of them with the exception of a few sql scripts.
After a little bit of digging, I noticed that all
o
Hi,
How do i turn off autocommit in dbi::Oracle
Anurag
On Wed, Aug 01, 2001 at 02:16:00PM -0700, Jeff Zucker wrote:
> [For those of you who may be wondering what the *)(# Squish has to do
> with DBI, it is among other things, a way of testing the new pure perl
> SQL::Statement which, will be subclassed by DBD::AnyData, maybe also by
> DBD::CSV? and DB
I did some tests and found out that it gives an error only if I try to use
bind variables. I i insert literals it works fine.
for example if I use code like this it works
$sth = $dbh->do(" Insert into ofas values ('a','a','a','a',1,1,'1')");
### $sth->bind_param(1,$company)
Thomas, any chance you could update the README.help file about Irix
and send me a diff -c that I can patch into my copy for the next release?
Tim.
On Fri, Aug 03, 2001 at 08:01:23AM -0700, Thomas A. La Porte wrote:
> You have two options, based on whether you want to build (or have
> built) Perl
Hello,
I am having some problems with my program running very slow and I hope you
can help me figure out what I may be doing wrong:
I am using DBI ver 1.14 and DBD-Oracle ver 1.06. I am extracting some
data from our database which has around 2.7 million records. The program
would be running
Hi All,
Was hoping some one maybe able to explain this error when attempting to LOCK
MySQL tables for READ and WRITE:
Error Encountered:
Unable to LOCK tables.
Error: Not unique table/alias: 'members'
The correct database has been connected to, and the members table is a valid
table. It's exe
- Forwarded message from Mauricio Amorim <[EMAIL PROTECTED]> -
From: "Mauricio Amorim" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Oracle database
Date: Fri, 3 Aug 2001 12:31:41 -0300
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="=_NextPart_000_11C5
You have two options, based on whether you want to build (or have
built) Perl -64 or -n32.
If you need n32, you'll have to order or download the Irix N32
Development Toolkit, which provides the basic set of client
libraries in n32 form, rather than the 64 bit libraries.
Alternatively, you can bu
Strip the code to the minimum and do a trace.
-Original Message-
From: Phan, Robert [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 02, 2001 4:08 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Multiple select statements
>If you are executing the same statement with different parameters more
At 3:18 PM -0500 8/2/01, Purcell, Scott wrote:
>I have an insert string that has a single quote " ' " in it, and it is
>causing my dbi to die. I can escape it in perl, but I believe I have read in
>the DBI book a way to quote the string before sending it to the DBI. I just
>can't find it in the bo
On Wed, 1 Aug 2001 15:26:54 -0700 , Brose, Eric wrote:
>Too few parameters.
That is the typical way of Access to complain that one of your field
names in the SQL statement couldn't be found in the table.
--
Bart.
It looks like your Oracle environment variables are not set for the user that owns
your web process.
Set the env directly in your perl script before you load the module.
ie.
$ENV{ORACLE_HOME} = where/oracle/lives;
$ENV{LD_LIBRARY_PATH} = /where/oracle/libs/live/
use DBI;
Rick
Sr. System Admin
Le
>If I use something like:
>my $data= $sth->fetchall_arrayref;
> foreach (@$data){
> print qq(@$_);
> }
>
>
>I get all the data, but how the hell do I access the specific
>elements in
>this array of arrays? Is there a better fetch method to use?
my $data = $sth->fetchall_arrayref;
# Prin
This would be nice if this was a ratings/comments list, but this is a
programming DBI list. Everything that you described below, we would need to
have in actual code, not necessarily the whole module, but snippets that
refer to the problem area. We can then comment on what is it you are doing
wr
>This would be nice if this was a ratings/comments list, but this is a
>programming DBI list. Everything that you described below, we would
>need to
>have in actual code, not necessarily the whole module, but snippets that
>refer to the problem area. We can then comment on what is it you are
>d
I really doubt it's a DBD::Oracle related problem, too. I've had queries
with multiple subqueries that executes withing milliseconds.
Ilya
> -Original Message-
> From: Wilson, Doug [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 02, 2001 4:38 PM
> To: 'Phan, Robert'; '[EMAIL PROTECT
23 matches
Mail list logo