hi there
I am using the dbi proxy. there are two scripts that work on the same mashine with the
proxy. now I copy the scripts to another server and try to connect. all I got was the
following message
Cannot log in to DBI::ProxyServer: Cannot connect: Bad file descriptor at
Hiya all,
I have (for illustration purposes) two tables in an ODBC database:
Table 'Jobs'=JobID,JobDescription,JobDate
Table 'Users'=UserName,JobID,LastViewedDate
Basically I want to select all JobID's and JobDescriptions from Jobs
where the user has a 'lastvieweddate' within the last 10
On Tue, 14 Aug 2001 11:12:23 +1000, Neil Lunn wrote:
Use something like this as the record source for items with duplicate email
addresses:
select *
from table
where email in (
select email
from table
group by email
having count(*) 1)
and delete every second record.
Next question:
On Mon, Aug 13, 2001 at 10:49:33AM -0700, Tim Harsch wrote:
True.
And it makes no matter to me cause I understand that, and probably no matter
to most because they get it too, but what about the people that don't
understand that or first timers that are learning DBI and they learn that
-Original Message-
From: Jon Barker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 8:28 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: SQL Statement - Selecting details if they exist if not...
I'm not completely sure I understand you but:-
select * from Jobs
-Original Message-
From: Bart Lateur [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 8:30 PM
To: [EMAIL PROTECTED]
Subject: Re: Removing duplicate records - OT
On Tue, 14 Aug 2001 11:12:23 +1000, Neil Lunn wrote:
Use something like this as the record source for items with
Are you sure
1. The proxy daemon is up and running?
2. you can connect from the new script machine to the database
server machine? Try telneting from the new script machine
to the dbi proxy port on the database server - if dbiproxy is
running, your telnet on the script machine
On Tue, Aug 14, 2001 at 11:12:23AM +1000, Neil Lunn wrote:
Use something like this as the record source for items with duplicate email
addresses:
select *
from table
where email in (
select email
from table
group by email
having count(*) 1)
and delete every second record.
Forgot to mention maintaining an index on the orf column in each table to speed
up the order by, and running VACUUM ANALYZE on a table any time it changes
substantially, or at appropriate intervals. Is it possible to make orf an
integer if it isn't already? Remember that the index will slow
I am receiving the following error:
Can't call method func on an undefined value at
C:\Inetpub\scripts\convertOptran.pl line 382, line 532.
And the offending line of code is marked by ' -- BAD CODE! BAD!'. I
checked the passed arguments, which all check out. I do not
On Tue, Aug 14, 2001 at 06:38:06AM -0700, Vuillemot, Ward W wrote:
I am receiving the following error:
Can't call method func on an undefined value at
C:\Inetpub\scripts\convertOptran.pl line 382, line 532.
And the offending line of code is marked by ' -- BAD CODE!
Why are you explicitly calling DBI-install_driver? According to the DBI docs,
it gets called implicitly by DBI-connect. You might try to do a $dbh-ping
both after the DBI-connect and after the DBI-install_driver lines, to verify
that the connection is working. It's clear that $dbh isn't a
Hello All,
When setting AutoCommit = 0, with transactions, does anything else need to be
set to disable Autocommit? It seems that the Autocommit = 0 is being ignored in
our script. If it's set to '0' is still seems to process the queries with or
without invoking the $dbh-{'commit'} and no error
I am trying to locate pre-compiled packages for the Win32 platform (Windows
2000 + ActiveState Perl), for the latest versions of DBI (1.19) and
DBD-Oracle. The ActiveState module archives only contain version 1.14 of the
DBI module.
Any ideas/leads?
TIA
Sanjay
Hi,
I used to use DBD:Oracle and it worked fine.
I'm using ActivePerl 5.6.1.
Now I switched to DBD:Sybase. I installed the Sybase module via
ActiveState
ppm.
So far ok.
When I tried to execute a perl script connecting to a sybase db I get
the
error that the dynaLoader.pm can't load the
Hello,
I am trying to build the DBD::FreeTDS module for Perl, but
I am encountering and error when I do the perl makefile.pl
command :
Died at makefile.pl line 47.
%RMS-F-SYN, file specification syntax error
Line 47 happens to be :
die unless -e $dbidir/DBIXS.h;
I have installed DBI 1.19
Falk writes:
Hi,
I used to use DBD:Oracle and it worked fine.
I'm using ActivePerl 5.6.1.
Now I switched to DBD:Sybase. I installed the Sybase module via
ActiveState
ppm.
So far ok.
When I tried to execute a perl script connecting to a sybase db I get
the
error that the
Piyush Avichal writes:
Hello,
I am trying to build the DBD::FreeTDS module for Perl, but
I am encountering and error when I do the perl makefile.pl
command :
DBD::FreeTDS is dead (I guess it should really be removed from
CPAN...)
Try downloading the FreeTDS libraries
Can you provide some code?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 10:02
To: [EMAIL PROTECTED]
Subject: auto commit
Hello All,
When setting AutoCommit = 0, with transactions, does anything else need to
be
set to disable
On Tue, Aug 14, 2001 at 04:45:10PM +0200, Ton Verhagen wrote:
Dear All,
I am experiencing some problems installing DBI-1.19 on a clean RH7.1 system
running perl-5.6.1
make: *** No rule to make target `blib/arch/auto/DBI/Driver.xst', needed by
`Perl.xsi'. Stop.
make: *** Waiting for
Here is a very trimmed down sample snip:
$dbh-do('LOCK TABLE members WRITE');
$dbh-do('begin');
$query = qq|UPDATE members SET payment = ? WHERE username = ?|;
$sth = $dbh-prepare($query);
$sth-execute($pay,$user);
$sth-finish() if $sth;
$dbh-do('commit');
$dbh-do('UNLOCK TABLE');
Hello,
I have just attempted to build and install DBI-1-19 for Perl.
I am running Perl 5.6.1 on VAX/VMS 7.1 using MMK 3.9.2
and using DEC C 5.5.
Whilst doing the MMK and the MMK Install I got the following
messages in both:
Can't open output file [.blib.man1]dbiproxy.pl.rno as stdout
Your problem is your database structure. Instead of putting things into
500 tables, you should merge them into 1 table.
This is not a perl question, its a database design question.
-alex
On Mon, 13 Aug 2001, Evan Zane Macosko wrote:
Hi everyone,
I am use Perl:DBI to interface to a
You don't mention which database, which might make a difference.
The finish() after the UPDATE won't do what you think it will. It should
only be used after a SELECT query. The cheetah book talks about it on p.
117.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Hi,
We are migrated our Oracle7.0 to Oracle8.1.6, The perl programs were
written using oraperl.pm script to connect to database, and now
we are trying to install Oracle DBD:DBI modules, Is it going to be
smooth transition? any ideas?
Our old perl programs are going to work?
Pl . let me know.
Is there a perl DB2 group where I can post my question?
-Original Message-
From: Matthew Johnson
Sent: Monday, August 13, 2001 9:32 PM
To: '[EMAIL PROTECTED] '
Subject: delete with DBI and DBD::DB2
Hello,
I'm using DBI with DBD::DB2 connecting to a DB2 database(who'd a thought)
[snip,
Dear Sir,
I've found your email in the DBI's perldoc.
So, what i found seems to be a bug of sql-parsing
Here is a fragment of tracing:
dbd_st_preparse: statement = select * from dirs_items1 where dirid like ?||'\\_\%'
escape '\\' and lang=?
dbd_preparse scanned 1 distinct placeholders
Of
You need to search in Activestate if it is for Win32, I am wondering how did you
search for that did you searched for DBD-Oracle Using PPm?
- Original Message -
From: Sanjay Perl
Sent: Tuesday, August 14, 2001 11:31 AM
To: [EMAIL PROTECTED]
Subject: Win32 distribution for DBI/DBD
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 12:49
To: [EMAIL PROTECTED]
Subject: Re: auto commit
On Tue, 14 Aug 2001 12:26:39 -0400, [EMAIL PROTECTED] wrote:
You don't mention which database, which might make a difference.
Which version of MySQL? In the CREATE TABLE statement for members, did you
specify the table type that uses transactions? (Can't remember what it is right
this second.) Does your actual code execute more than one statement inside the
transaction? If not, there's not much point to using it.
Thanks,
that's the problem, their using MYISAM tables, not Innodb or BDB table handlers
so it won't work! Damn,.. guess that answer that question.. :)
Tue, 14 Aug 2001 15:12:48 -0400, [EMAIL PROTECTED] wrote:
Which version of MySQL? In the CREATE TABLE statement for members, did you
Hello all,
I am trying to retrieve a record that may/maynot have a null value in it.
this is what i am doing, however there its not really working. I can feel
there is a simpler way of doing it, but unfortunately i am clueless in that
sense. Can anybody make sense out of it???
Thanx a lot.
PS:
I am trying to insert using the following statements. Somehow,
VARCHAR NULL can be inserted, but the NUMBER NULL keeps giving me
ORA-01722: invalid number (DBD ERROR: OCIStmtExecute).
What did I do wrong? Thanks!
$insert = INSERT INTO test_database (TEST_PRIOR, TESTER_IP_ADDR,
TEST_DURATION,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, Aug 14, 2001 at 02:32:04PM -0600, HUA, Qing wrote:
I am trying to insert using the following statements. Somehow,
VARCHAR NULL can be inserted, but the NUMBER NULL keeps giving me
ORA-01722: invalid number (DBD ERROR: OCIStmtExecute).
On Tue, Aug 14, 2001 at 02:32:04PM -0600, HUA, Qing wrote:
I am trying to insert using the following statements. Somehow,
VARCHAR NULL can be inserted, but the NUMBER NULL keeps giving me
ORA-01722: invalid number (DBD ERROR: OCIStmtExecute).
What did I do wrong? Thanks!
$insert =
HUA, Qing wrote:
I am trying to insert using the following statements. Somehow,
VARCHAR NULL can be inserted, but the NUMBER NULL keeps giving me
ORA-01722: invalid number (DBD ERROR: OCIStmtExecute).
What did I do wrong? Thanks!
$insert = INSERT INTO test_database (TEST_PRIOR,
Now I remember that I've read it somewhere...
Thanks for the help! It is working now.
On Tue, 14 Aug 2001, Stephen Clouse wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, Aug 14, 2001 at 02:32:04PM -0600, HUA, Qing wrote:
I am trying to insert using the following statements.
We've been noticing that often times DBD::Informix is not returning the
whole error message generated by the database. For example, I received
the following string in response to a char to numeric conversion error:
SQL:-1213:
However in the Apache error_log, I get:
FastCGI: server
Tim/All,
We have been using perl at Bristol-Myers Squibb for quite a while
now.
I had a small concern, We have recently moved to Oracle 8i and
were facing some dead lock problems. We thought it might be DBi
or DBD . So we up graded to DBI version 1.18 .
--Do you recommend to Upgrade the DBD
It's almost always best to upgrade. Most new releases include bug fixes,
new functionality, etc..., unless there are specific problems, you should
upgrade.
Ilya
-Original Message-
From: Harsh Pandey [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 1:35 PM
To: [EMAIL
40 matches
Mail list logo