> Network Blitz
> I am having some problems installing DBD::mysql and was wondering if anyone
> had any idea why I am getting the error listed below.
unset LANG; # should take care of your problem.
And it looks like you are using an old version of DBD::mysql.
Rudy
http://search.cpan.org/~timb/DBI/DBI.pm#Threads_and_Thread_Safety
Tim.
On Thu, Mar 11, 2004 at 12:05:40PM -0500, Arnold, Hugh wrote:
>
> I want to spin off $sth->execute() & just this statement into a thread, so I
> can perform other tasks while the database is preparing the results of my
> quer
Laurie Vien wrote:
I am on the very last step of my Perl script.
Congrats!
$sql_cmd = "\"UPDATE Chunkmail SET Contribute_flag=1 WHERE
Chunkmail_ID=" . @contribute_flag[$_] . "\"";
$rslt = $dbh->do($sql_cmd);
Try:
$sql_cmd = q{
UPDATE Chunkmail SET Contribute_flag=1 WHERE Chun
> I am on the very last step of my Perl script. Have read a
> bunch of records
> into arrays, using a 'select table handler' with DBI. Now I
> want to cycle
> back through the data in those arrays, and based on the value of one
> specific field, update a field in the corresponding database rec
Never mind, folks--sorry for the interruption. I tried just putting the SQL
command--array element and all--into the "do" statement, and got rid of the
$sql_cmd variable, and it worked.
I guess you can take those error messages literally sometimes ...
-Original Message-
From: Laurie Vi
I am on the very last step of my Perl script. Have read a bunch of records
into arrays, using a 'select table handler' with DBI. Now I want to cycle
back through the data in those arrays, and based on the value of one
specific field, update a field in the corresponding database record.
Because I
I want to spin off $sth->execute() & just this statement into a thread, so I
can perform other tasks while the database is preparing the results of my
query. Like:
my $sth=$dbh->prepare(...);
my $thread=async{$sth->execute()};
...do other stuff for a while...
$thre
[sent to Tim rather than the list by mistake]
--- Begin Message ---
David Wheeler wrote:
> /usr/local/lib/perl5/site_perl/5.6.1/i386-freebsd/BerkeleyDB.pm line
1388, line 23.
That directory wasn't in the @INC you sent yesterday. Something odd is
going on.
--
Jeff
--- End Message ---
I am getting the following error when trying to install Bundle::DBD::mysql
or DBD::mysql. Any ideas as to why ?
Unsuccessful stat on filename containing newline at
/usr/lib/perl5/5.8.0/ExtUtils/Liblist/Kid.pm line 97.Unsuccessful stat on
filename containing newline at /usr/lib/perl5/5.8.
Network Blitz
I am having some problems installing DBD::mysql and was wondering if anyone
had any idea why I am getting the error listed below.
#---#
Which drivers do you want to install?
1) MySQL only
2) mSQL only (ei
>>> "Zhang, George" <[EMAIL PROTECTED]> 03/11/04 10:03AM
>>>
Yes, it is possible to connect to Oracle on Windows (actually, it
doesnot
matter what OS oracle runs on since Oracle takes care of network
communication).
You need to install Oracle client on your linux system. The doc here
is
very hel
Yes, it is possible to connect to Oracle on Windows (actually, it doesnot
matter what OS oracle runs on since Oracle takes care of network
communication).
You need to install Oracle client on your linux system. The doc here is
very helpful:
http://www.oracle-base.com/articles/9i/Oracle9iInstallat
Yes, it is possible to connect to Oracle on Windows (actually, it doesnot
matter what OS oracle runs on since Oracle takes care of network
communication).
You need to install Oracle client on your linux system. The doc here is
very helpful:
http://www.oracle-base.com/articles/9i/Oracle9iInstallat
Hai
I am working on Redhat Linux system with Perl. But I
want to connect with Oracle 9i database in my Network.
But The Oracle is installed in Windows System. Is it
possible to connect the Oracle 9i by using Perl
script. If possible pls guide me ( I am new for
database connection ).
If u know
Bjorn,
Yes, I had thought of that and the impact on disk space/fragmentation of
constant drops and creates. I've actually run into another problem possibly
to do with global names - my insert loks like this :
insert into TESTTABLE select * from [EMAIL PROTECTED]
The SID.DOMAIN.COM is what I retr
Mark Martin wrote:
my $fields = join(', ', @cols);
my $values = join(', ', @rows);
$sql02 = qq{"INSERT INTO DATA__WAREHOUSE($cols) VALUES ($rows)"};
Shouldn't $sql02 be using $fields and $values instead of $cols and
$rows? And why not just grab the column names from $sth->{NAME} after a
dummy s
thanks everybody - sometimes you dig yourself into hole when a simpler
solution is staring you in the face. If anybody has cracked a method of
inserting into column names held in an array, data that is also held in an
array - I'd be interested for future reference - for now I'll be linking
databas
Source Database x with table a
Target Database y , table b.
1. Create a databaselink on database Y going to X as readuser or as
schema owner.
2. create table b as select * from [EMAIL PROTECTED];
3. remove databaselink
kind regards
Bjorn Naessens
-Original Message-
From: Hardy Merr
If your goal is just to make an exact copy of a table to a table with a
different name, you may not need DBI for that. I just did this a few
weeks ago in Oracle - this is from memory and may not be quite right,
but you'll hopefully get the idea:
create table table_b as (select * from table_a)
Hi,
We have an application which gives a corba interaface. We have written a
perl script to pull data out of the interface and dump the same to the
Oracle database. All we do with oracle is to take an database connection
using DBI of the format
$dbh = DBI->connect ('', $user_id, $password, 'Ora
Hello,
I'd like to get some feedback on an idea for a new DBI wrapper, or a
lightweight object-relational mapping if you prefer to look at it that way.
The main goal is ease of writing a simple database app. The thing that
distinguishes it from all the other DBI wrappers out there is that the d
- Forwarded message from [EMAIL PROTECTED] -
Delivered-To: [EMAIL PROTECTED]
Subject: RE: DBI with ORACLE encryption
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
From: [EMAIL PROTECTED]
Date: Thu, 11 Mar 2004 12:06:29 +0530
Hi,
We have an application which gives a corba interaface. We
The best way of copying a table in oracle is by creating a database link and
Usine the CREATE TABLE AS syntax
CREATE TABLE $table_name AS
SELECT * from [EMAIL PROTECTED]
Andy
> -Original Message-
> From: Mark Martin [mailto:[EMAIL PROTECTED]
> Sent: 11 March 2004 09:22
> To: [EMAIL P
Hi,
bin using DBI for a while for data warehousing type stuff and up till now I've had to
change data on the fly as it moves from one database to another :
my $sql01 = qq{SELECT FIELD01 .FIELDn FROM PRODUCTION_TABLE};
my $sql02 = qq{INSERT INTO DATAWAREHOUSE VALUES (?,?,?);
my $s
On Wednesday 10 Mar 2004 7:06 pm, News Reader wrote:
> On Wed, 10 Mar 2004 12:50:59 -0600, "Brad Fike" <[EMAIL PROTECTED]>
> said:
>
> Thanks for the ideas. I did try entering them in as blanks, but I still
> got this error:
>
> DBI->connect(BWEB) failed: [Microsoft][ODBC SQL Server Driver][SQL
> S
25 matches
Mail list logo