Hi Glen,
I hope you don't mind the (nearly) fullquote to keep the list informed.
G S [EMAIL PROTECTED] wrote:
Hi Hans,
Thank you for your response. I was able to capture $retCode using your
suggestion. I eventually removed the error handler (after the ||) just to
isolate something I do
Hi,
I am a happy user of DBD::Sybase to enable my perl to talk with MS SQL
Server.
The DBD::Sybase I am using is .tar.gz, I need distribution in .rpm as the
deployment machine don't have make :)
What I have done is the following:-
(1)
/usr/lib/rpm/cpanflute2 DBD-Sybase-0.94.tar.gz //
Lincoln Stein wrote:
My test case is part of a big script that requires BioPerl. What I'll do is
to pull it out into a self-contained script.
Frankly I don't think that this has anything to do with DBI, but rather
something fundamental that changed with Perl's IO handling. A whole bunch of
There seem to be conflicting versions of DBI::Format in
DBI-1.34 and DBI-Shell-11.91.
After upgrading to the recent DBI-1.34 I again get
a warning from the CPAN r command which reports that
there is a more recent version of DBI::Format to
be found in DBI-Shell-11.91.tar.
When I read that the
I am tracking down an issue where an error condition is not returned from a
call to $sth-execute().
Here is my example code with comments. I show the output for 3 tests. Test
1 and test 2 produce results that I understand. The problem is in test 3.
In test 3 I would expect the returned
I have been posting messages here by emailing to [EMAIL PROTECTED] Is
there a way to post messages so that they are part of an ongoing thread?
Thanks.
_
Protect your PC - get McAfee.com VirusScan Online
I searched google, but could not find the answer.
We are using
oracle 9.2.0.2.0
SunOS enigma 5.7 Generic_106541-18 sun4u sparc SUNW,Ultra-4
This is perl, v5.6.1 built for sun4-solaris
DBI 1.34
but when I was trying to install DBD:Oracle 1.12
at make test, I got
Test returned status 255
Hello,
I have changed from
MySQL DB to CSV File (DBD::CSV).
And also from Linux to Windows
A)
But now I discovered few problems:
On the same hardware system
the same select for the same table
1) Linux the select takes 0.4 seconds
2) Windows the select takes 2.1 seconds
Using Apache 1.3.27
On Sat, 01 Mar 2003 12:02:15 -0800 G S [EMAIL PROTECTED] wrote:
I have been posting messages here by emailing to [EMAIL PROTECTED] Is
there a way to post messages so that they are part of an ongoing thread?
That is a function of your email client. Normally, if you reply to a
message, the
I ended up changing all my references to CGI-BIN to cgi-bin and ran
into the same problem as before when I'd purposely *uppercase* the
cgi-bin portion of the url.
I ended up creating a shortcut to cgi-bin which is called CGI-BIN and
added that directory to the appropriate sections of the
On Sat, Mar 01, 2003 at 11:10:34AM -0800, David Dyck wrote:
There seem to be conflicting versions of DBI::Format in
DBI-1.34 and DBI-Shell-11.91.
After upgrading to the recent DBI-1.34 I again get
a warning from the CPAN r command which reports that
there is a more recent version of
On Mon, 3 Mar 2003 08:23:11 -0500 Cory Rau [EMAIL PROTECTED] wrote:
I ended up changing all my references to CGI-BIN to cgi-bin and ran
into the same problem as before when I'd purposely *uppercase* the
cgi-bin portion of the url.
I ended up creating a shortcut to cgi-bin which is called
Hello,
I have changed from
MySQL DB to CSV File (DBD::CSV).
And also from Linux to Windows
There's the first two mistakes! :)
A)
But now I discovered few problems:
On the same hardware system
the same select for the same table
1) Linux the select takes 0.4 seconds
2) Windows
Not sure with windows, probably should see apache.org for details, but it seems
That perhaps
There is a 'ScriptAlias' directive for CGI-BIN but not cgi-bin.
I'd try adding that in your httpd.conf file or making some kind of symlink or alias
with each other for both versions.
Also it may be an
Sounds like the cgi-bin directory is in the document_root hierarchy it
doesn't match the ScriptAlias and get executed so it is just returned as a
text file. Make sure the cgi-bin is in a different directory path not in
document root then you'll just get a Document not found error.
NOTE: Pure
From: Dan Muey [EMAIL PROTECTED]
A)
But now I discovered few problems:
On the same hardware system
the same select for the same table
1) Linux the select takes 0.4 seconds
2) Windows the select takes 2.1 seconds
Using Apache 1.3.27 and under Windows ActivePerl.
Is it a
On Fri, 28 Feb 2003 20:21:29 -0500, Cory Rau wrote:
I
purposely mistyped the url with 'cgi-bin' rather than what it actually
is, 'CGI-BIN' just to see what would happen. I ended up getting the
entire *code* of the perl script in my web browser
This is OT for perl-DBI, but...
I think that
Hello,
thanks for your answers.
I would also like to stick to MySQL, but I have to change it,
since there is no DB-Server available.
Use a remote one, your isp's perhaps. Anywho...
Dan, yes the data of the tables are *exactly* the same!!!
How about posting the first few lines form
On Sat, 01 Mar 2003 12:02:15 -0800, G S wrote:
I have been posting messages here by emailing to [EMAIL PROTECTED] Is
there a way to post messages so that they are part of an ongoing thread?
Select reply to respond. Make sure [EMAIL PROTECTED] is amongst the
recipients. That's it, basically.
I have already realized that simply stripping out the semi-colon will not work with
all situations. I even posted something to that effect.
It would have been nice to know if, say, someone had worked out something to process
SQL files since this is such a common task and developers who don't
Peter Schuberth wrote:
On the same hardware system
the same select for the same table
Please check your version of SQL::Statement which is the module that
determines the speed and capabilities of DBD::CSV. Put these two lines
at the top of the scripts:
use SQL::Statement;
print
Snethen, Jeff wrote:
I've worked with the DBI some, but I'm now starting to experiment with DBD::CSV. I'm
trying to read a table without
column headers, letting CSV create the column names for me. If I understand the
documentation correctly, an empty array
reference should cause the driver to
On Mon, 3 Mar 2003 09:42:51 -0800 Fernando Luna [EMAIL PROTECTED] wrote:
It would have been nice to know if, say, someone had worked out
something to process SQL files since this is such a common task and
developers who don't use perl but work with Oracle frequently use SQL
files.
Bulk
On Mon, Mar 03, 2003 at 10:07:29AM -0800, Jeff Zucker wrote:
Peter Schuberth wrote:
On the same hardware system
the same select for the same table
Please check your version of SQL::Statement which is the module that
determines the speed and capabilities of DBD::CSV. Put these two lines
I am trying to do either :-
Retrieve data from an Oracle table with a nested table column
or
Retrieve data from an Oracle object table based on an object which contains
a nested table
Either attempt results in :-
DBD::Oracle::db selectrow_array failed: ERROR OCIDefineObject call needed
but not
Hi Michael,
Attached are 2 files. One is a build script for a Sybase stored procedure
(fill in the database name). The other is a perl script (fill in the
connection information).
The reason I am raising this issue is that I found I had to code for special
conditions during error handling
On Mon, 3 Mar 2003 20:50:09 - Simon Taylor [EMAIL PROTECTED] wrote:
I am trying to do either :-
Retrieve data from an Oracle table with a nested table column
or
Retrieve data from an Oracle object table based on an object which
contains a nested table
Either attempt results in :-
Ok thanks - just wanted to check it wasn't down to how I was using it
Michael A Chase [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Mon, 3 Mar 2003 20:50:09 - Simon Taylor [EMAIL PROTECTED]
wrote:
I am trying to do either :-
Retrieve data from an Oracle table with a
I am trying to insert into a table which has a nested table.
I have an array in Perl which I want to load into the nested table.
I have a variable number of entries in the array and dont want to have to
enumerate them.
How can I load my data into a nested table?
Please has anybody got a similar problem and a fix
I've already installed DBI.1.21 on 2 Sun servers with Solaris 8 ...one was a 32 bit
and the other a 64 without any problems well not too many !!
But on this server its proving impossible ...I've also tried a different dbi ..1.34
On 2003-03-03 13:35:36 +0100, Peter Schuberth wrote:
I have changed from
MySQL DB to CSV File (DBD::CSV).
And also from Linux to Windows
Neither seems like a smart move to me.
Changing two things at once definitely isn't.
A)
But now I discovered few problems:
On the same hardware system
Hello,
thanks for your answers.
I would also like to stick to MySQL, but I have to change it, since there is
no DB-Server available.
Dan, yes the data of the tables are *exactly* the same!!!
The querry I use for C) is like:
where (field1=?) and (field2=?) order by field3
again the same data
Hello Jenda,
I have used the same data under Linux and Windows, also the same scripts.
The times I gave in A) are only for the select of the CSV table not for the
script. But comparing the select query with the execution of the rest of the
script, select is taking most of the time. Under Windows
I am trying to do either :-
Retrieve data from an Oracle table with a nested table column
or
Retrieve data from an Oracle object table based on an object which contains
a nested table
Either attempt results in :-
DBD::Oracle::db selectrow_array failed: ERROR OCIDefineObject call needed
but not
I am trying to do either :-
Retrieve data from an Oracle table with a nested table column
or
Retrieve data from an Oracle object table based on an object which contains
a nested table
Either attempt results in :-
DBD::Oracle::db selectrow_array failed: ERROR OCIDefineObject call needed
but not
I have this script:
use strict;
use warnings;
use DBI;
my %attr = (
PrintError = 0,
RaiseError = 1
);
my @drivers = DBI-available_drivers();
foreach my $driver(@drivers) {
print Driver: $driver\n;
my @dataSources = DBI-data_sources($driver);
foreach my
On Mon, Mar 03, 2003 at 04:25:13PM -0500, Bob X wrote:
I have this script:
use strict;
use warnings;
use DBI;
my %attr = (
PrintError = 0,
RaiseError = 1
);
my @drivers = DBI-available_drivers();
foreach my $driver(@drivers) {
print Driver: $driver\n;
my
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Anyone using perl 5.8.0?
After a lot of upgrades (seg fault, DBI connect hangs), we seem to have one old RedHat
server happy w/ 5.8.0.
Linux version 2.4.7-10 ([EMAIL PROTECTED]) (gcc version 2.96 2731 (Red Hat Linux
7.1 2.9
6-98)) #1 Thu Sep 6
connect_cached creates a _new_ connection on the second call
in this sample (only difference being PrintError attribute)
DBI-connect($data_source, $user, $auth, {PrintError=1});
DBI-connect($data_source, $user, $auth, {PrintError=0});
I would submit that this is wrong behavior, and that the
Tim Bunce wrote:
On Mon, Mar 03, 2003 at 04:25:13PM -0500, Bob X wrote:
I have this script:
[...]
It simply gives me a list of DBD drivers installed. Ran fine until I upgrade
to 1.34 at which point I get the following error now:
install_driver(Proxy) failed: Global symbol $this requires explicit
IBM Informix Database Driver for Perl Version 2003.03.0303 (2003-03-03) has been
uploaded to CPAN.
IBM Informix Database Driver for Perl (also known as DBD::Informix) is
the driver code that enables Perl 5.005 or later to access Informix
databases via the DBI module (but if you are not already
I've discovered that DBD::mysql will return tablefoo.fieldbar as
the NAME of the field in a select like:
SELECT tablefoo.fieldbar FROM tablefoo
It does that simply because that's what the underlying mysql client
API tell it is the name of the field.
I believe this is very rare (I know of no
At 0:18 + 3/4/03, Tim Bunce wrote:
I've discovered that DBD::mysql will return tablefoo.fieldbar as
the NAME of the field in a select like:
SELECT tablefoo.fieldbar FROM tablefoo
That's not what I observe. Is this a recent change in the MySQL C client
library? The library has not
43 matches
Mail list logo
