-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, March 24, 2003 4:58 PM
To: [EMAIL PROTECTED]
Subject: OLDB - ODBC
Does this belong in the DBI list? Sorry if the answer is yes.
*
Hi,
We have a problem. We run Perl for Window NT. We
Create a dummy table and try :)
José.
> -Original Message-
> From: Brian Avis [mailto:[EMAIL PROTECTED]
> Sent: Friday, March 07, 2003 2:52 AM
> To: dbi-users
> Subject: Dropping tables
>
>
> Can I do this via DBI connecting to a PostgreSQL database?
>
> $dbh->do("DROP TABLE $tablenam
Is it possible to do something similar with Java ?
José.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 30, 2003 5:39 PM
> To: NYIMI Jose (BMB); [EMAIL PROTECTED]
> Subject: RE: Perl OO - Dynamic method call
>
>
This is a little bit Out of Topic but if somebody can give input I will greatly
appreciate!
I know that in Perl OO the name of a method can be a variable.
Which end up with code like this:
my $obj= new MyClass;
#here the thing
$obj->$method();
$method var holding the name of my method.
I would
http://xmlproj.com/fom-serve/cache/13.html
http://search.cpan.org/author/TIMB/DBI-1.32/
José.
> -Original Message-
> From: nick shen [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 18, 2002 2:15 AM
> To: [EMAIL PROTECTED]
> Subject: How to install DBI in Windows 2000
>
>
> Hi
>
Hello,
As far as I know, fetchrow_hashref() return a hashref
with colum_name as keys.
My question is:
Is there a way to say to fetchrow_hashref() to return a hashref
where keys will contain both table_name and colum_name ?
I know that I can use aliases in my sql statement like this :
$sql=" sel
Hello,
As far as I know, fetchrow_hashref() return a hashref
with colum_name as keys.
My question is:
Is there a way to say to fetchrow_hashref() to return a hashref
where keys will contain both table_name and colum_name ?
I know that I can use aliases in my sql statement like this :
$sql=" sel
rom cni_function
where id=al_id
);
else
[snip]
> -Original Message-
> From: Michael A Chase [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 18, 2002 4:43 PM
> To: [EMAIL PROTECTED]; NYIMI Jose (BMB)
> Subject: Re: Execute an Oracle Function (not
Hello,
I have a function in our Oracle database (a function, not a procedure).
I would like to execute this function from my perl script using DBI.
I wrote something like this :
my $sql=qq[
BEGIN
OWNER.MY_FUNCTION(?,$action,?,$meta_type);
END;
];
my $dbh=DBI-
I'm trying to install perl modules (DBI actually ...) for windows using
PPM.
My connection is via proxy and I have set HTTP_proxy , HTTP_user and
HTTP_pass variables ...
When I type the ppm command : search *
I got the following messages:
Searching in repository 1 (ActiveState Package Repositor
-Original Message-
From: loan tran [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 23, 2002 5:12 PM
To: [EMAIL PROTECTED]
Subject: perl and DB connectivities
Howdy,
Does someone know if there is a function in sybperl
(use Sybase::DBlib) which does exactly the same thing
of: $data =
> Yes. There is more to DBI than the Perl sections. There are
> also .xs and .c files. Keep looking for 'trace', not 'sub trace'.
Mamamiya ! :-)
Thanks ...
DISCLAIMER
"This e-mail and any attachment thereto may contain information which is confidential
and/or protected by intel
> It's in the source archive, DBI-1.30.tar.gz. Extract all the
> files and grep for 'trace'. Note that trace() itself is
That is what I did and I thought that I will find some where( not in
lib/DBI/PurePerl.pm file)
a line beginning with:
sub trace{
None
Is that part written in C ?
Jo
> -Original Message-
> From: Hardy Merrill [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 19, 2002 1:26 PM
> To: NYIMI Jose (BMB)
> Cc: Tim Bunce; Dolan, Mark; Perl Users Help (E-mail)
> Subject: Re: Problem populating execute using @array.
>
>
&g
Hello Tim,
I'm very interested by DBI->trace method.
I gave a look in DBI.pm, I can't find the implementation.
Where it is ?
What is the meaning of this line:
'trace' => { U =>[1,3,'[$trace_level, [$filename]]'], O=>0x04 },
Thanks in advance for your help.
José.
> -Original Me
Start look from here : http://search-dev.cpan.org/src/TIMB/DBI_Talk5_2001/sld024.htm
Index: http://search-dev.cpan.org/src/TIMB/DBI_Talk5_2001/index.htm
José.
-Original Message-
From: Ildar Gabdulline [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 01, 2002 6:40 PM
To: Matthew O. P
To avoid dbh beeing distroyed without disconnection from DB,
change the _init() sub like this
(oups ! Super:: should be SUPER:: I guess :)
sub _init{
my($self,@args) = @_;
ref($self) || croak "$self is not an object\n";
#let DBI to make the connection and keep the dbh a
I didn't test the code I suggest below but may be this can provide you Some new ideas:
package Db;
use base qw(DBI);
use strict;
#
#Constructor
#
sub connect{
my($caller,@args) = @_;
my $class=ref($self) || $caller;
my $self={};
bless $sel
(BMB)
Cc: [EMAIL PROTECTED]
Subject: Re: Hard-coding SQL in DBI violates OO encapuslation ?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, Jul 31, 2002 at 09:25:15AM +0200, NYIMI Jose (BMB) wrote:
> Dear,
>
> A friend recommended me this white paper:
>
> http://w
Dear,
A friend recommended me this white paper:
http://www.ambysoft.com/persistenceLayer.html
The Author suggests to implement what he called "Robust Persistence Layer" between
"Business Classes" and "Storage mecanism" (ex Relational Database").
Here an extrait from the white paper:
"This ap
Give a look to
http://aspn.activestate.com/ASPN/Reference/Products/ActivePerl/faq/ActivePerl-faq2.html
HTH,
José.
-Original Message-
From: Narayan, Raj [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 6:20 PM
To: [EMAIL PROTECTED]
Subject: RE:DBI MODULE FOR WINDOWS
Hi Everybo
Hello,
I would like to write a script (with DBI) that convert my Oracle table to CSV file.
What is the best way.
Is there a module to do that ?
My apologies if the response already in one FAQ list :-).
Thanks,
José.
DISCLAIMER
"This e-mail and any attachment thereto may contain i
cgi-list or beginners-cgi
At
http://lists.perl.org/
José.
> -Original Message-
> From: Jonathan Gines [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 17, 2002 12:21 AM
> To: Stephen Keller; [EMAIL PROTECTED]
> Subject: RE: DBI works, but CGI + DBI bombs?
>
>
> Stephen,
>
> I have impl
Oups!
I meant
perldoc -f system
perldoc -f "exec"
José.
> -Original Message-
> From: Anand Kumar [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 16, 2002 4:58 AM
> To: [EMAIL PROTECTED]
> Subject: Unix command in Perl
>
>
> Hi,
>
> I had to issue a UNIX command "source DBINST* " fr
perdoc -f system
perdoc -f "exec"
Or use backtick stuff
$result=`your_unix_command`
José.
> -Original Message-
> From: Anand Kumar [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 16, 2002 4:58 AM
> To: [EMAIL PROTECTED]
> Subject: Unix command in Perl
>
>
> Hi,
>
> I had to issue a
TECTED]]
> Sent: Wednesday, May 15, 2002 2:18 PM
> To: NYIMI Jose (BMB)
> Cc: [EMAIL PROTECTED]
> Subject: Re: DBI -- DBD -- UML
>
>
> Try this:
> http://search-dev.cpan.org/src/TIMB/DBI_Talk5_2001/sld046.htm
> http://search-dev.cpan.org/src/TIMB/DBI_Talk5_2001/sld047.
Hello,
I guess the "Object Oriented" concept has been used to implement the DBI class
(package).
Is there any UML diagrams ? (which explain for example the relationship (inheritance
?) between differents involved classes)
Thanks,
José.
DISCLAIMER
"This e-mail and any attachme
> -Original Message-
> From: Dave K [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 19, 2002 4:16 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Syntax for Driver Specific attributes
>
>
> Jose,
> Tried that, no good!
> Upgraded to DBI 2.01 same result (access violation)
Try upgrading yo
> -Original Message-
> From: Dave K [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 19, 2002 2:07 PM
> To: [EMAIL PROTECTED]
> Subject: Syntax for Driver Specific attributes
>
>
> Hi All,
> I'm trying to use driver specific attributes,
> specifically pg_type:
>
> my @tables = $
http://otn.oracle.com/doc/server.815/a66736/ch63.htm#307
José.
-Original Message-
From: Michael A Chase [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 19, 2002 7:03 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: (Fwd) Do you know how to select * from a.table1@oracle_database1
1. try this command line:
ldd /home/csc/sps/perl/lib/site_perl/5.005/sun4-solaris/auto/DBD/Oracle/Oracle.so
It will tell you if you are missing some libraries.
You can also use ldd -s (to see more ...)
2. export LD_LIBRAY_PATH=$ORACLE_HOME:$LD_LIBRAY_PATH
3. If you have changed something from O
According to Ilya in one his reply :
Ilya wrote:
[BEGIN]
You need a Visual C++ compiler in order to compile any perl modules for ActiveState
perl, and it's utility is nmake not make. cl is the actual compiler.
You don't have to do it though as you can install binaries already precompiled.
I
While( $array_ref = $sth->fetchrow_arrayref() ) {
#recordset treatement here ...
}
José.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 11:34 AM
To: [EMAIL PROTECTED]
Subject: How to retrieve multiply recordsets returned by s
Hello,
I've found it very handy downloading perl from www.activestate.com as pre-compile
package, ready to be used, you no longer need to (trouble :-)) perl makefile.pl, make,
...and so on. Click and use !
Why DBI can not be downloaded as a pre-compile package, ready to be used on Windows OS
When you run perl Makefile.pl
this create automatically a Makefile in the current directory.
Could you show the content of this Makefile, please?
Jose.
-Original Message-
From: tied [mailto:[EMAIL PROTECTED]]
Sent: woensdag 20 februari 2002 9:30
To: [EMAIL PROTECTED]
Subject: Please help
Hello, I need your help!
I've got the following massage :
Can't load
'/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBD/Oracle/Oracle.so
'
for module DBD::Oracle: ld.so.1: /usr/local/bin/perl: fatal:
libclntsh.so.1.0:
open failed: No such file or directory at
/usr/local/lib/perl5/5.6.
Use DBI Proxy Server.
It was designed for those kind of problem.
José.
-Original Message-
From: Justin Derrick [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 29 januari 2002 17:06
To: [EMAIL PROTECTED]
Subject: Re: Accessing a remote DB
I'd be curious to know if any of the DBD modules suppor
Hello,
Is there somebody who can tell me how I can execute
a Stored Procedure with Oraperl ?
I know that is possible to do that with DBI but
I have a constraint to keep Oraperl that I'm using now.
Thanks in advance,
José.
DISCLAIMER
"This e-mail and any attachment thereto may cont
I think you have to try this instead:
$sth=$dbh->do("BEGIN index_reporting.index_report($pass) END";);
or explicitly like this:
$sth=$dbh->prepare("BEGIN index_reporting.index_report(:1) END";);
$sth->bind_param($pass);
$sth->execute();
-Original Message-
From: Stan Brown [mailto:[EMA
]]
Sent: zaterdag 18 augustus 2001 18:45
To: NYIMI Jose (BMB); [EMAIL PROTECTED]
Subject: RE: Remote DB Connection
Well if you use DBD::ODBC for which you will have to have third party ODBC
software installed, then just set up a DSN and use that in your connection.
Anyways just see perldoc DBD
How I can connect to a remote Informix database ?
The database from which I would like to extract
data (a simple SQL select ...) is installed on a remote machine(Solaris 8).
The local machine is also a Sun machine using Solaris 8. I don't have
an Informix database installed on this local machin
41 matches
Mail list logo
