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 PRO
Hi, How are you, i try to install the DBI in my server but i have a
problems, the trace is in the next file.
Oscar Daniel Islas R.
52681254
perl.log
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 versi
I am not a programmer. I solved my OBCD problem.
I am getting all your e-mails and I do not have a clue as to how to stop
them.
I would love to help, but I do not have a clue about programming. I was
looking for a way to fake out a microsoft upgrade into thinking I had a
product that it was look
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
"/apache/
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 statem
"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,
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
-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).
>
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, T
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:
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 yo
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.
-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.
M
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
I
Sorry I don't have a lot of time right this moment to investigate
further, taking a quick glance at the code,
if (in_literal) {
/* check if literal ends but keep quotes in literal */
if (*src == in_literal && *(src-1) != '\\') {
in_literal = 0;
}
*dest++ = *src++;
contin
Actually the preparsing is done by the DBD's. Look at the
dbd_preparse() function in dbdimp.c file under DBD::PG dist.
On 15-Aug-01 Anar R Guliev wrote:
> 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 t
I am trying to locate a pre-compiled version of DBI (1.19) and DBD-Oracle
(latest) for the Win32 platform and have had no success so far. Does anyone
have any additional information about this, or could point me in the rigth
direction?
Thanks,
Sanjay
__
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
O
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,
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.
Th
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]]
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');
$dbh-
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
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 Auto
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 (http://www
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 t
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 a
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 Sybase.dll.
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
_
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 Po
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 erro
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
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!
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
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 do
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 sec
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 mach
>-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 item
>-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 * fro
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
%RMS-F-SYN
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
I'm not completely sure I understand you but:-
select * from Jobs left outer join Users on Jobs.JobID=Users.JobID;
Should give all the jobs, with null user data where there isn't a
user associated with a job.
Jon
> Hiya all,
>
> I have (for illustration purposes) two tables in an ODBC datab
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
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 days.
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
/usr/lib/perl5/site
Hi i have a problem printing a lob field containing an image.
The database i use is Interbase 6.0
I have a blob/lob field with a gif image inside an i like to print this
image on the web.
Can you help me?
Bye Alessandro
>-Original Message-
>From: Konstantin [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, August 14, 2001 5:38 PM
>To: [EMAIL PROTECTED]
>Subject: rollback
>
>
>Hi.
>
>I'm trying to use the rollback function but I get the error:
You've been moved to dbi-users where this sort of enquiry belongs.
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 Sybase.dll.
49 matches
Mail list logo